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.