DSXchange

Hi,

I have a Datastage job, which is insertind data in to a temp_arg table and it had two fields Strt_Date and End_Date with Date data type .

In my job the input column data that I'm using to load the Strt_Date and End_Date fields is '2010-10-10 00:00:00.00' .

In ORAOCI9 stage I defined the Strt_Date and End_Date columns as Timestamp and the Sql that is gernerated in OCI stage is

INSERT INTO tmp_parm_rang (TPR_STRT_DT,TPR_END_DT) VALUES (TO_DATE(:1, 'YYYY-MM-DD HH24:MI:SS'),TO_DATE(:2, 'YYYY-MM-DD HH24:MI:SS'))


After running the Job I don't see any data in the database and the Datastage job finished successfully with out any warning.

Can some one help me in understanding why data is not loaded in the oracle Database


Thanks,
Somaraju

Do you have reject link to ORAOCI9 stage?

Check performance statistics in the job and see how many rows are sent to ORAOCI9 stage.

Use Iconv function to convert date.