CHGPF error in Iseries v5r4

40 pts.
Tags:
AS/400 errors
CCSID
CHGPF
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.."



Software/Hardware used:
Iseries db2/400 v5r4

Answer Wiki

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

EIT,is right!

Delete the exxisting object of FILEA and recreated it using new CCSID.

Discuss This Question: 6  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
  • ElTerrifico
    If the files are empty, can you delete it and recreate it from the source instead of doing a CHGPF?
    620 pointsBadges:
    report
  • TomLiotta
    What is the error message identifier? The text doesn't help us much since many errors may result in similar (or identical) text. Usually, such a message indicates that there are other messages that pin-point the specific error. Knowing the message identifier will help us determine what else to look for. Tom
    125,585 pointsBadges:
    report
  • AS400TEC
    Please find the job log below for the above error. Message . . . . : Change to field FLDA may result in data loss. Cause . . . . . : A change to field FLDA in file FILEA in library LIBA may cause data loss. The reason code is 8. The reason codes and their meanings are as follows: 01 - The field will be dropped. 02 - The new length is shorter than the current length. 03 - The new precision is shorter than the current precision. 04 - The new scale is shorter than the current scale. 05 - The new data type is floating point and the current data type is not floating point with the same length. 06 - The current data type is floating point and the new data type is not floating point with the same length. 07 - The new attribute is not nullable and the current attribute is nullable. 08 - The new CCSID is different from the current CCSID. 09 - The new data type is date, time, or timestamp and the current data type is character, DBCS-open, or DBCS-either. 10 - The new data type is character, DBCS-either, or DBCS-only and the current data type is DBCS-open, or the new data type is character or DBCS-only and the current data type is DBCS-either. Recovery . . . : If the changes to field AIER are not desired, change the specified attributes of field AIER and try the function again. CPF7304 Escape 40 File FILEA in LIBA not changed. Thanks,
    40 pointsBadges:
    report
  • AS400TEC
    It is a part of batch job which runs daily to change all the files as per the requirement. Compiling physical files will lead to compilation of the programs also which is not feasible. Thsnks,
    40 pointsBadges:
    report
  • ASWDEVELOPER
    this would be a last resort ... recompile the file with level check *NO ...
    405 pointsBadges:
    report
  • TomLiotta
    recompile the file with level check *NO … Although this can be a valid option, I would not suggest it to those who are unfamiliar with the basics of what it means. There are serious risks that need to be considered and decided. Without the knowledge foundation, LVLCHK(*NO) needs to be avoided by a long distance. As for the current error: Message . . . . : Change to field FLDA may result in data loss. This is what we would need the message identifier for. However, most likely, the message ID is CPD32CC. If this is the only diagnostic message and the condition is acceptable, then the CHGPF command might be run with GENLVL(21) as an additional parameter. I think that this particular warning is a severity 20, but I'd need to see an actual compiler listing example to be sure. When severity 20 diagnostics are understood and acceptable, they can usually be allowed. In this specific case, it seems to be the intent to accept this potential data loss. I suspect that no actual data loss will occur. There is more that should be covered, but probably in a separate question. I'm concerned about the business process behind this comment: It is a part of batch job which runs daily to change all the files as per the requirement. I'd recommend that the whole requirement be posted in a question for more discussion. It seems odd to say the least. Tom
    125,585 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