Hi,
I am loading a file to a DB2 table using load utility. I have a new column included to the table. While loading the table, this column is loaded incorrectly. All 0's in the input file is loaded as 15 and all 2's as 47 and so on. Field in file is Pic 9(3) Comp-3 and that in table is SMALLINT not null with default. Rest of the columns all loaded correctly. Can someone explain why is there a inconsistency in this load?
Field in Input file:
2/P
(778-779)
355------------
************-CAPS
0
0
0
2
0
57
38
8
Field in DB2:
SMALLINT
--------
*********
15
15
15
47
15
1407
911
143
Thanks,
Sharmila