AS/400

5 pts.
Tags:
AS/400
AS/400 administration
PF
How to change the field name in PF?

Answer Wiki

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

Thank you for visiting ITKE.

We are happy to help you with solving specific IT questions, but need as
much information as possible to do so. Let us know about the problem you
are trying to solve, how you are approaching it and what work you’ve
done so far, and we can help guide you in the right direction.

Discuss This Question: 3  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
    Sure, this might be a homework or Inverview question but it might not...   Warning this may have an adverse impact on existing programs, queries and other uses for this file.   1. Change the "DDS" source   2. Use the CHGPF prompt it and identify source - this command will change the file and logicals that use the file format   or   Use the SQL Alter Table Command  
    49,970 pointsBadges:
    report
  • TomLiotta
    Changing the name of a field is not very different from creating a new file. I would probably use CREATE TABLE ... AS ... WITH DATA. I don't know that using CHGPF has any way to retain data from the renamed field. -- Tom
    125,585 pointsBadges:
    report
  • graybeard52
    I would probably create a new field with either DDS or SQL, populate it with data on "old" field, then delete the old field. Depending on requirement, creating a LF or SQL view might also work, although this doesn't actually change the PF
    3,115 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