Page 1 of 1

How to load data from a (15,2) table to (16,0) table

Posted: Fri Dec 24, 2010 10:39 am
by archup20
I have test table which has colums of size (15,2) and I have extract data from these Tables and load it into production table where the same colums are of size (16,0).How do I do this?.Thanks in advance.

do not use size in your posts - impolite
moved to db2 forum

Posted: Fri Dec 24, 2010 5:49 pm
by Natarajan
one solution is .. unload data from source table..
convert the file using cobol program to 16,0 length.. based on business rules provided by the client.

load that file to target db2 table.

Posted: Wed Dec 29, 2010 4:30 pm
by archup20
I used a JCL to convert 13,2 to 15,2 but from 15,2 I have to load to a 16,0 table.
I am not able to write a code for that. Can u please give an idea how to write that code

Posted: Wed Dec 29, 2010 5:18 pm
by dbzTHEdinosauer
well you are going to truncate data if you go from 13,2 (or 15,2) to 16,0.
why do you want to do that?