Changing a physical file definition

1930 pts.
Tags:
AS/400
Physical File
I’m trying to prove how this happened. The file in TEST has an old creation date on the object but it includes 2 new fields. So not done via recompile. Is there another way to change a file definition without recompiling? I suspect maybe SQL? Please keep it simple with any reply – I don’t want to do this but rather I just want to prove how it was done. We installed an unrelated change and were surprised to get a Level Check on that file.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, the ways Philip mentioned. That is a problem that goes with giving the flexibility to the IT staff. In my old department the CHGPF command was restricted to QSECOFR. In the case of the SQL ALTER TABLE,  the programming staff could only use SELECT statements. A little power in the wrong hands can be a big problem. They set this to prevent file corruption and crashes of our corporate software.

Discuss This Question: 2  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
  • philpl1jb

    Columns can be added using CHGPF or using SQL ALTER TABLE commands.

     

    49,910 pointsBadges:
    report
  • aceofdelts

    Thanks for the info !

    FYI - it turned out to be much more useful than I'd expected. One of our contractors fessed up to doing this (no attempt to "snow" me thanks to this specific info) and I used this to reverse-out what he had done.

    1,930 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