Do we need to compile LF when its PF changes

100 pts.
Tags:
AS/400 DB2
Hi, I have one small query. I have changed one PF, do I need to recompile it's dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate your quick response !

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: 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
  • NeilD
    A few questions:Have you Compiled the PF?Did you compile the PF in the same library as the dependant LF's?Basically, in order to compile the PF you will need to delete the LF's and recompile them after the PF has compiled. The the answer to you wuestion is Yes, you must recompile dependant Lf's. 
    485 pointsBadges:
    report
  • philpl1jb
    1.  If you used the command CHGPF or SQL ALTER TABLE you will not need to recompile the logicals   2.  If the logical has a field list you may want to add the field to the logical and recompile the logical. 
    50,465 pointsBadges:
    report
  • ToddN2000
    Thought I learned something new today. Tried the CHGPF command and it worked fine. New fields were in both th PF and LF without having to recompile them. The only problem I found is you still get a level check on the programs using the LF.  Is there a way to avoid this with out setting the file to *LVLCHK *NO?  
    12,980 pointsBadges:
    report
  • philpl1jb
    No .. since you've changed the physical file and the logical file structure you want the programs to fail!!!  (what if you made the first field in the file one character wider.....).     
    50,465 pointsBadges:
    report
  • TomLiotta
    If the format level identifier changes for a file, programs that open the file will need to be recompiled in order to avoid a level check.   It doesn't matter how the file was changed. If a PF was changed with CHGPF and the related LFs received a new level ID, programs that open the LFs will need to be recompiled.   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