Iam giving in transformer Derivation as If (isnull(docnum)) then 0000000001 else docnum . Iam loading to a seq file and DB2 table but when Iam loading Iam getting as 1 instead of 0000000001 the left side zeros are deleted . Please help me how to achieve 0000000001 instead of 1.
If the column definition on the DB2 table is some kind of integer, the leading zeroes are redundant and therefore not stored.
If the column definition specifies Char, then leading zeroes can be kept.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
What is the value for docnum. By any chance is docnum is equal to 1?
Are you doing any type conversion after the transformer?
What is the datatype of the field in the transformer which holds the value?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'