Datastage issue in loading zero

Question

Using Datastage 11.5.0.2, Jobs failed when it try to load the data as "0" into DATE FIELD (DB2)..

In source DB, the column is VARCHAR whereas in target it is DATE field.. the only value in source which failed to load is 0. how to resolve.. any idea pl

score 1 · Accepted Answer · answered Jan 19 '18 at 14:38

1

Create one stage variable: if (input column value ) = 0 then use StringToDate("0001-01-01", "%dd:%mm:%yyyy") Else StringToDate(inputcolumn, "%dd:%mm:%yyyy")

answered Jan 19 '18 at 14:38

Ganesh Mantri

26
2

score 0 · Answer 2 · answered Apr 02 '18 at 23:39

0

You can use the in the transformer stage,

StringToTimestamp(Column,"%yyyy-%mm-%dd")

also you can convert data in Source qualifier by using below in select query

   to_date(column,"%yyyy-%mm-%dd")

answered Apr 02 '18 at 23:39

Sukriti Singh

43
1
2
13

score 0 · Answer 3 · answered Feb 13 '19 at 06:53

0

Can use the to_date function

to_date(column,'YYYY-MM-DD')
TO_DATE(column, 'YYYY-MM-DD HH24:MI:SS')

answered Feb 13 '19 at 06:53

jpn

43
9

Datastage issue in loading zero

3 Answers3