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 |
How can you delete records form a file in rpg without using "Delete" OPCODE?
In a particular program one file is used where override command is applied to a file, now this program calls another program where we want to use the same file but without override.How it can be done?
wat is scan and check ? give me real time scenarios where we used these keywords in ur projects?
i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.
Hi, Can anybody give me real sinario for SFLRCDNBR?with example?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
Can a indexed file be accessed in arrival sequence in RPG?
Why Rpg/400 is Famous?
if i have three programs progA,progB and progC .now i call progB from progA. but the progB does not exist . now i want to call progC instead of starting dump. how can we achieve this.
what do you mean by SESSION/DEVOCE ERROR?
I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....
how do u find whether a record is locked or not??/