RE: Advise on a Database Change

Doesn't matter.  You'll have to write a conversion program (or so some stuff
with SQL) to convert the numeric data to the character field and you'll have
to recompile all programs using the record format.  Application
logic/editing changes may be required too.


-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
Behalf Of Giri Gopal
Sent: Wednesday, August 22, 2001 12:12 PM
To: rpg400-l@midrange.com
Subject: Advise on a Database Change

Hi:

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?

Thanks for your advice in advance.

GG

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com