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 |
In ProgramB there is a SBMJOB, which is a call to program C .There is also a CALL to program D from B. How would you check the program C has been executed in D?
How to identify the object has compiled with the debug view as *source without using STRDBG?
parameters cannot be passed in which one??
What is ment by record level identifier?
If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?
what is post opcode do
how do you use commitment control in rpg?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E
we are sending data of physical file to screen design and it is showing no record why?
I have a file .In that file i have 3 fields. Those fields are eno, ename, esal.Keyfield is eno. In that file i have data like this for eno 1,2,3,4,5. Now i need to display 2nd record. That means i need to set the pointer on 2nd record... Then, write the complete rpg program using setll.
Difference between RESET and CLEAR