Sort problem while loading into db2 table

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sort problem while loading into db2 table

Postby nallac » Mon Jan 10, 2011 8:25 pm

I am trying to load data from a flat file to a db2 table,

my data in flat file is like this

first 9 characters are decimals and they represent a integer column in the table, so i need to convert this into binary format before loading into table, and for that i am using the below conversion card


for sure the data is being converted to binary but always in the flat file i have to keep 9 characters of decimals like 654312978 , if i use below nine like 376, while loading it is loading as 376000000 instead of 376 alone, i tried this even by aligning 376 to right justified, keeping the remaining initial six as spaces, but even then the result is 376000000, can any one suggest me a sol for this prob.
Posts: 1
Joined: Mon Jan 10, 2011 8:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort problem while loading into db2 table

Postby skolusu » Mon Jan 10, 2011 10:47 pm

Use UFF format to reformat the numeric data

Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times



  • Related topics
    Last post