IBM DB400 Interview Question:

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

Submitted by: Administrator

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.
Submitted by: Administrator