Home > IT Answers > AS/400 > Add a new field in PF
jainamit
380 pts.
 Add a new field in PF
Physical Files, RPG

Is it possible to add a new field in an existing PF without deleting the records that are present in it?

 



Software/Hardware used:
ASKED: March 14, 2013  12:59 PM
RELATED QUESTIONS
Answer Wiki:
Ravula is correct if hte file was created with DDS. Just change the DDS and do the CHGPF command. You will need to recreate the LFs and recompile programs using the files. (PF & LF)
Last Wiki Answer Submitted:  March 14, 2013  3:08 pm  by  CharlieBrowne   33,730 pts.
All Answer Wiki Contributors:  CharlieBrowne   33,730 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

yes we can add feilds to a existing pf .without deleting the records.you can achive it through CHGPF command

you can google for more info

Thanks
ravula

ravula
 615 pts.
 

Columns may also be added (or removed or changed) with SQL by running an ALTER TABLE statement with an ADD FIELD clause (for adding). — Tom

TomLiotta
 110,175 pts.
 

Thanks
Amit
 

jainamit
 380 pts.
 

Note that LFs that do not use the new field and have explicit field lists do not need to be recompiled nor do programs that use those LFs. — Tom

TomLiotta
 110,175 pts.