Home > IT Answers > AS/400 > iSeries Navigator V5R3M0
RBDSILVA
180 pts.
0
Q:
iSeries Navigator V5R3M0
iSeries Navigator, V5R3, DDS, Logical File, iSeries
Hi all, I have a DDS from a logical file on my system:

A R I55120 PFILE(F55120)
A K ICBOX
A S ICSTAT COMP(EQ 'I')
A ICTIPC COMP(EQ '1')

How can I make this index using "a comparison value for fields" on Iseries Navigator ?

Thanks
Silvarb
ASKED: Jun 18 2009  3:39 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Cwc
3825 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hi,

I'm not a great user of iSeries Navigator for DB management but if I'm not wrong it uses SQL to create indexes and you can't create "selection" indexes with SQL.

Regards,
Wilson

----------------
However, if you want to have a filtered set of records through SQL, you'd probably want to create an SQL view. An example is:
Create View MYLIB/MYVIEW As
Select *
From MYLIB/MYTABLE
Where (ICStat = 'I' And ICTIPC = 1)

CWC
*--*--*--*--*--*
Last Answered: Jun 19 2009  1:51 PM GMT by Cwc   3825 pts.
Latest Contributors: WilsonAlano   2005 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

SBatSI   370 pts.  |   Jun 18 2009  5:47PM GMT

Silvarb -

I think you will get more help if you give us more information. Where specifically are you working in iSeries Navigator? What are you trying to accomplish?

Regards,

Steve B

 

WilsonAlano   2005 pts.  |   Jun 19 2009  9:18PM GMT

CWC,

Yes you can create a view to select records but a view can not be indexed.
Wilson

 

Cwc   3825 pts.  |   Jun 22 2009  2:18PM GMT

Yes, I am aware of that, so it would need a combination of a proper index and a view, so that the view could easily retrieve the records as specified in the criteria.

 

Graybeard52   2355 pts.  |   Jun 22 2009  5:04PM GMT

Cwc,
You do not need an index to select from a view - just use the “where” cluase to select. If you want better performance, run your query thru “Visual Explain” and build the indexes it suggests. The indexes will be over the PF and not the view.

 

Cwc   3825 pts.  |   Jun 23 2009  1:21PM GMT

Yes, I am aware of that as well - my point was that some type of index is needed, whether it’s an existing one that can be used, or if the system recommends another one, in order to efficiently access the data requested by the Select statement in the view.

 
0