there is a requirement to change the existing decimal (20,3) datatype to decimal (25,3) datatype in a table with records. if i m correct one cannot alter the column length to increase the length.
I drop and recreate the table with the increased length after a unload.
if the data is loaded back to the newly created table with the increased col length, will the load be succesful.

pls suggest any inputs to handle this scenario

you are correct, and you would still us the same load card that got created from thhe unload

Isn't DB2 fun!