DSXchange

Hi,

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.




Thanks,
Somaraju

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.

Hi Ray,

The columm definition is char and I want to load in both sql file and DB2 table .Plz tell me how to achieve it






Thanks,
Somaraju.

What is the definition in the DB/2 Table for this column? If it is also char(10) then try using "0000000001" with quotes.

Hi

Exactly when ever you loading data first in sequentialfilestage/fileset then DB2 we need to do the below thing for char/Varchar Datatypes

you need to use the hardcode thing in " "(Double Code) in the Derivation part


Regards
Shiva Kondeti

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?

Hi Kumar,

Iam not doing any type conversion my problem was solved by giving the value inside the quotes .


Thanks a lot for all the posters who solved my problem





Thanks,
Somaraju