IBM DB400 Question:
Download Job Interview Questions and Answers PDF
How to add a field to a PF and compile it without loss of data?
Answer:
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.
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.
Download IBM DB400 Interview Questions And Answers
PDF