• AS/400: Add some fields in the physical file

    Hi! Actually I have a physical file containing 400,000 records. I just want to add some fields in that file and it is referred by many programs. I know that I can use CHGPF. But I'm a bit afraid to change a big database. What are the necessary steps I can take on these process and proceed further?...

    Sureyz2,735 pointsBadges:
  • Add a field in existing file in DB2/400

    I need add a field in existing Physical file without impacting any other file? I know the CHGPF command but I'm not sure about which parameter needs to be update. Please advice.

    Askt265 pointsBadges:
  • CHGPF doesn’t change the based on LFs

    I used the CHGPF command to change the record layout of a Physical File but the based on Logical Files were NOT changed - the Format Level Identifier still had the old value. 

    QCDT25 pointsBadges:
  • Can we change length of CSV File

    Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the legnth of CSV file?

    deepu93214,775 pointsBadges:
  • How do I change the field length in a physical file using chgpf command?

    Hi,  This is giri.Im looking to change the field length in pf using chgpf command?Please give me what are the steps i have to do?How can i change the field?

    Girilabs130 pointsBadges:
  • CHGPF error in Iseries v5r4

    The CHGPF command is giving error when used to change the CCSID from 37 to 285 in a pf in iseriee V5R4. The files are empty but it is showing the error as " Error occured during the update of physical file PFILEA in library LIBA using source file located in library LIBINST.."

    AS400TEC40 pointsBadges:
  • Problem in CCSID converting

    I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...

    Proturborandza25 pointsBadges:

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.

Thanks! We'll email you when relevant content is added and updated.