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

OUTREC FIELDS=(1:1,9,ZD,TO=BI,LENGTH=4,)

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.
nallac
 
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

  OUTREC FIELDS=(1:1,9,UFF,TO=BI,LENGTH=4,..
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post