how to change the length of the field in a physicalfile?
Answers were Sorted based on User's Feedback
Answer / shanky
CHGPF Command:-
You need to Change DDS of Physical file for Changing Fileds
Length. and after det u need to complie it but if you
complie it then u will loose Existing Data of ur File.
So By Using CHGPF Command u can Keep ur Existing Data with
Compilation Of changed fields(DDS).
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / vani
i think by using the CHGPF it is possible.if anybody tell
me is it right or wrong
| Is This Answer Correct ? | 18 Yes | 9 No |
Answer / gautam
As per my understanding,we can not change length of a field
in a physical file using command CHGPF.Using this command
we can change number of records and so on.
If we want to change length of a field then we have to
change its source where we previously defined the size of
the field and then requires a compilation.After compiling it
we delete all logicals based on this physical file then
file is re-build in respective file groups from where
prorams use records.
Please let me know if there is any issues!
| Is This Answer Correct ? | 13 Yes | 5 No |
Answer / sachin
By Using CHGPF, We can Change Length add New field or
change field Attributes in PF
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / abhishek bajpai
Hi All,
Just to elaborate on the above answers..offcourse CHGPF is
correct and we can just press enter on this command and it
modifies the object based on the current DDS keeping the
data intact. But there are a couple of things to be taken
care of in this:
1.> If we are increasing the field lenghts then there is no
problem at all and chgpf runs absolutely fine.
2.> If we are decreasing the field length, then in case of
character field it will give warning as the existing
records might be truncated because of the shortened length.
But in case of numeric field the caommand will fail because
OS400 cannot truncate the existing numeric data and the
command blows up.
3.> If suppose the command is successfully run and the
field length is changed in the PF then there r chances that
the LF wont reflect the change. If in LF Pfile is mentioned
and no fields (that means the whole record format is copied
from PF) then it will reflect the new length. But in case
you have mentioned certain fields in LF then it will keep
on showing the old lenght inspite of the fact that in PF
the lenght is changed. This is because here the field
attributes are copied to LF from the PF when it is compiled
and it keeps on showing that length only.
Thanks
Abhishek Bajpai
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ramaraju
By using CHGPF comaand we can change the pf attribute size.
And another way is
copy the physical file into another dummy file(for that
use Cpyf)
and change the physical file field length ,compile it
Then again copy the data from dummy file to original file
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / abhishek kumar
I agree that we can do this using the command CHGPF but
whether any one can tell which paramter we need to change
in CHGPF?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manu som
By using CHGPF comaand we can change the pf attribute size.
And another way is
copy the physical file into another dummy file(for that
use Cpyf)
and change the physical file field length ,compile it
Then again copy the data from dummy file to original file
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / swapnil sanghai
Hi All,
just wanted to check if it works for PF ( Flat Physiccal
File ). I do not see option for changing the length of
file. Can you please correct me if im wrong .
| Is This Answer Correct ? | 0 Yes | 2 No |
Hi guys. Im in AS/400(RPGLE,CLP) from last 1 year.Now i wan to upgrade my Knowledge in AS/400. Suggest me some new fields & courses which falls under AS/400. Waiting for your quick Response.
Why Rpg/400 is Famous?
what is meant by record lock.how records are locked.what is the purpose of record lock.if records are locked what happens.how to find out which record is locked.
What is the purpose of FRCDTA keyword?
use of PUTOVR,OVRDTA,KEEP keywords?
What is Multi Occurrence Data Structure(MODS)?
Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any
How can you delete records form a file in rpg without using "Delete" OPCODE?
How can you determine the number of characters in a variable?
which MONMSG will give higher priority in CL program? I know MONMSG are of two types. Program Level Monmsg and Command Monmsg?
Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?
can anyone say,what is the use of operation extended H/N/P?