AS/400 – DB2/400 PF and LF have different identifiers for Synon

305 pts.
Tags:
AS/400
DB2/400
Synon
Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

Software/Hardware used:
Software

Answer Wiki

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

i can tell you about what is the difference between db2/400 pf and lf, first , pf the database file which contain the data material, the as you entered into the file, but lf is the file which the data is sorted by one or more of items or fields of the pf 

Discuss This Question: 3  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
  • TomLiotta

    Manually created files PF and LF have same file level identifiers.

    A "file level identifier" is just a creation timestamp. If any two files have the same "file level identifier", it's only because their CRTxxx commands ran within the timestamp interval. There is no other meaning to the "file level identifier".

    Tom

    125,585 pointsBadges:
    report
  • philpl1jb
    Generally the important thingy is the Format Level Identifier.
    50,860 pointsBadges:
    report
  • Lilarose22
    When a Synon physical is created, it automatically creates the logical and retieval paths, thus the time is the same, and the file ID also.  The LF/RF is just a different view of the PF that is used for the purposes of retrieval/updating which is not done over the physical in Synon.  Because of that, it needs to keep those fields separately identified. Hope that helps
    60 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