IBM Mainframe Forum

I had a requirement to change column of a table from integer to char.The table has data.can any one pls tell the steps to do that.Data should be retained.

Hello,

Unload the data, make the column definition change, reformat the unloaded data to the proper format data, load the data.

Thanks for the reply.I tried that.The data is not gtting loaded.facing the below error.

DSNU390I -D820 151 06:06:10.78 DSNURWUF - INVALID CONVERSION FOR FIELD - ACCOUNT_NBR

151 06:06:10.80 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

Sorry..i didnot format the data.Could you please let me know how to format the data.

Hello,

Read the unloaded data with the old format data and write a new file with the data formatted to match the new column definition.

One way to do this would be to use your sort product. Another would be to write a little bit of actual code.

You could have unloaded char(int_col1). Sort is the way to go now I guess.