Are logical files and indexes the same thing?

351880 pts.
Tags:
AS/400
iSeries Navigator
Logical Files
My background is certainly in MSSQL and I've asked people at my company if they have created indexes on certain columns. They always says yes but point me to logical files.

When I'm using iSeries Navigator, logical files show up under the "Views" category. However, when I click "Indexes", nothing appears. This is making me believe that there are no indexes on any columns. So basically I'm asking this: Are logical files and indexes the same thing?

Answer Wiki

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

Discuss This Question: 2  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
  • philpl1jb

    In SQL you can create indexes and views and you are obviously familar with these.

    Using "native" AS/400 file creatin tool a logical file can be created.  It can contain an index and it can contain rules of file and field selection.  It can also contain join rules.

    Native Logical files will appear to you in the View list. 

    These logicals usually contain an index which provides similar access speeds as SQL indexes.  These views may restrict the record selection and/or field list. 

    50,860 pointsBadges:
    report
  • TomLiotta
    A SQL INDEX will be implemented as a form of a LF. It's essentially a subclass of LF. There can be significant differences, and some indexed LFs cannot be use by SQL. Regardless, if created with DDS, iNav will not list the LFs even if the SQL engine can use them as INDEXes. You'll have to ask IBM developers of iNav to find out why not. -- Tom
    125,585 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