Field Description

[S.Mildenberger]

If your just changing the text you can update the physical files with CHGPF and you won't have to recompile any programs. Scott Mildenberger

[leonwise]

Thanks for the quick response. I checked the command and it appears that I probably need to update the DDS and then run CHGPF since I see no field-related parameters in that command. My second issue is that some of the numeric fields were never initialized to zero and can cause a decimal data error. We still have some programs which have the file internally described and do not properly initialize the fields. Do you know if the CHGPF will try to resolve every field (resulting in decimal data errors) or just the text where I have made changes? Thanks again for your patience and kind assistance.

[S.Mildenberger]

Your correct in that you change the DDS source and then run CHGPF referencing that source. I don't know how CHGPF handles numeric fields with invalid values, should be simple to setup a little test case. Scott Mildenberger

[Guest.Visitor]

If you have SQL, you can use the "LABEL ON" command to change both the column headings and text of a field.

 LABEL ON COLUMN MYLIB/MYFILE (CUSTPART IS 'Customer Part Number') /* column headings are three 20-char descriptions */ LABEL ON COLUMN MYLIB/MYFILE (CUSTPART TEXT IS 'The Customer Part Number') 

Chris

[leonwise]

We have several fields which have been "retired" and we need to change text to avoid confusing users of query. Fields are set up using REF file. My question is, can I change it in the ref file and re-compile my DDS or do I have to recompile all programs. We do not use the level check.