1,565 pts.
 How to change a field description
I plan to re-use an unused field in a PF. Of course, I want to give it a new COLHDG. My question is ... how to do this without re-creating the PF? I did this once (4 years ago) but I don't remember what command I used to make it "take" (just changing the source code would not be sufficient)

Software/Hardware used:
as400
ASKED: January 22, 2013  7:34 PM
UPDATED: January 22, 2013  8:28 PM

Answer Wiki:
If you have DDS Source, you can make your changes there. Then do CHGPF Prompt on the command to put in the source file  Lib/Name You can change any of the values. If there is a potential for data loss, you will get a warning message to see if you want to continue. You can also use SQL ALTER TABLE  
Last Wiki Answer Submitted:  January 22, 2013  9:22 pm  by  CharlieBrowne   32,785 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,785 pts. , Michael Tidmarsh   11,380 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

thanks !  It works perfectly (as  expected)

 1,565 pts.