iSeries Navigator V5R3M0

550 pts.
Tags:
DDS
IBM iSeries
iSeries Navigator
Logical Files
V5R3
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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
*–*–*–*–*–*

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SBatSI
    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
    415 pointsBadges:
    report
  • WilsonAlano
    CWC, Yes you can create a view to select records but a view can not be indexed. Wilson
    2,600 pointsBadges:
    report
  • Cwc
    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.
    4,290 pointsBadges:
    report
  • graybeard52
    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.
    3,115 pointsBadges:
    report
  • Cwc
    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.
    4,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following