DSXchange

This is the desgin of my Job: DB2 Stage | | V Transformer ------> SeqFile | | V Shared Container The DB2 Stage has a join from 3 tables, for which the output happens to be some 19 rows. This I verfied by running the querry from DB2 Command Editor and also by clicking on 'View Data'. Now when I run t...

Hi, In my job, when, on the source side I click 'View Data...', then some 19 - 20 rows of data is being displayed.
But, when I run the job, 0 (ZERO) rows are being read!!


Plz explain.

The datatype is TImestamp. I have verified, populating, a Seq File, that the nano seconds are coming properly.... Also, am not using any othe Trans (Iconv or Oconv)... I ahve also tried inserting from Command Line...it is going abs fine... but the prob is coming from Ascential to DB2..... Even tried...

Yes...it is getting stored as 000000 only for microseconds...no rounding off to next highr sec is taking place......and also VarChar did not help...

Input = '2006-10-23 17:15:58.135789'
Output (SEQ File) = '2006-10-23 17:15:58.135789'
Output (Db2) = '2006-10-23 17:15:58.000000'

Krazykoolrohit wrote:can you post an exapmle?

INSERT INTO FDM1PA.PS_ASCDTTM (JOB,ASC_DTTM) VALUES (?,?);

I am writing the timestamp (YYYY-DD-MM HH:MI:SS.SSSSSS) into a DB2 tables, from a job.
The data when written to a seq file, is written with the microseconds., but when the same is written into a DB2 table, the microseconds change to '000000'.
How do I handle the issue.???