Re: Advise on a Database Change

--

>A need has arrived to change the field size of a field. This field is 10th
>field in a 125 fields file. The field size is 9 numeric. Need to change this
>to 22 bye character field.
>
>The questions is Do I change the type and size at the same location (10th
>field) and recompile the file, or remove the field and add the column at the
>end of the file?

Giri,

I think a two step conversion may do the trick:

1) Create the new PF and define that field as 9 CHAR. Create a LF over the
old (=original) PF and change the data type of that packed field to a zoned
numeric field. Copy the contents of the old PF to the new PF using the
special created LF (using CPYF). All numeric values in the old PF have been
changed to numeric CHAR data with leading zeroes.

2) Change the DDS of the new file and make the new CHAR field with a length
of 25. Then use command CHGPF and the conversion is done.

Hope this may be a solution.

Regards,

Carel Teijgeler.
--