How to add a field to a PF and compile it without loss of data?

Categories >> Software >> MainFrame >> IBM AS400 >> DB400
Suggest New Category

Question Posted / emailkarthick

7 Answers
27688 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to add a field to a PF and compile it without loss of data?..

Answer / s.kumar

First Add the fields whatever you want

then use CHGPF command

Physical file . . . . . . . . . > MyPf
Library . . . . . . . . . . . MyLib
System . . . . . . . . . . . . . *LCL
Source file . . . . . . . . . . MYSourceFile
Library . . . . . . . . . . . MyLib

Update the Physical file.No need to compile again.

Is This Answer Correct ?

24 Yes

0 No

How to add a field to a PF and compile it without loss of data?..

Answer / vijay

add the field in the last and don't change the sequence of the old field then only you can used the CHGPF effectively

Is This Answer Correct ?

9 Yes

2 No

How to add a field to a PF and compile it without loss of data?..

Answer / m.gupta

First add the field to existing pf for that u can do like this

2)Press 2 option for edit mode

3)Then go to the editor then u add the field in that editor what ever field u want

4)press f10 and write 'FILE' for saving file

5)Then u can write 'CHGPF'

6) Physical file . . . . FILE DEPT
Library . . . . . . MVLGUPTA2
System . . . . . . . . . . . . . SYSTEM *LCL
Source file . . . . . . SRCFILE QDDSSRC
Library . . . . . . MVLGUPTA2
7)Then click enter enter for 2 times

8)Then click UD and insert data

Is This Answer Correct ?

7 Yes

1 No

How to add a field to a PF and compile it without loss of data?..

Answer / ravi

Using CHGPF and CPYF you can add fields to a PF without
loss of data.

Thanks,

Is This Answer Correct ?

1 Yes

1 No

How to add a field to a PF and compile it without loss of data?..

Answer / mohan

The New field of the exisitng records would have a default
value

Is This Answer Correct ?

1 Yes

1 No

How to add a field to a PF and compile it without loss of data?..

Answer / mahalakshmi

ovrdbf command wuth out losing of data

Is This Answer Correct ?

0 Yes

1 No

How to add a field to a PF and compile it without loss of data?..

Answer / vishal

You can use ALTER TABLE in SQL to add a new field without compiling file or losing data

Is This Answer Correct ?

0 Yes

2 No

Post New Answer