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
Loading Data in to Oracle Table
Moderators: chulett, rschirm, roy
Loading Data in to Oracle Table
somaraju