Page 1 of 1

Sort problem while loading into db2 table

PostPosted: Mon Jan 10, 2011 8:25 pm
by nallac
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.

Re: Sort problem while loading into db2 table

PostPosted: Mon Jan 10, 2011 10:47 pm
by skolusu
Use UFF format to reformat the numeric data

  OUTREC FIELDS=(1:1,9,UFF,TO=BI,LENGTH=4,..