Inserting dates into Oracle
Posted: Wed May 23, 2001 4:59 am
Datastage/Oliver team,
I am having a problem with a visual job I have designed. It is not a complicated job but I am having trouble inserting rows into our Oracle table. The datastage job seems to convert some of the dates to NULL prior to insert (the dates are used for a unique key in the table) and therefore the job complains that it cant insert the row into the table.
Prior to the DB error code, the log states the following: ===========================
KCImport.Tcom_LOG: At row 1, link "Log_Info", while processing column "DATA_DATE" Value treated as NULL Attempt to convert String value "11-FEB-01" to Date type unsuccessful ===========================
I have debbuged the job and the Iconv/Oconv functions seem to be converting the date into an acceptable Oracle format.
Why would datastage say it is treating a value as NULL?
Regards,
David Nemirovsky.
IT Consultant (Contracted To Telstra)
Black Diamond
T e c h n o l o g i e s
Web: http://www.bdt.com.au
Level 5, 1 Southbank Boulevard,
Southbank, Victoria 3006
E-mail: mailto:david.nemirovsky@team.telstra.com
Telephone: (03) 8696 - 5983
Facsimile: (03) 9682 - 7074
Mobile: 04111 - 88 - 44 - 1
I am having a problem with a visual job I have designed. It is not a complicated job but I am having trouble inserting rows into our Oracle table. The datastage job seems to convert some of the dates to NULL prior to insert (the dates are used for a unique key in the table) and therefore the job complains that it cant insert the row into the table.
Prior to the DB error code, the log states the following: ===========================
KCImport.Tcom_LOG: At row 1, link "Log_Info", while processing column "DATA_DATE" Value treated as NULL Attempt to convert String value "11-FEB-01" to Date type unsuccessful ===========================
I have debbuged the job and the Iconv/Oconv functions seem to be converting the date into an acceptable Oracle format.
Why would datastage say it is treating a value as NULL?
Regards,
David Nemirovsky.
IT Consultant (Contracted To Telstra)
Black Diamond
T e c h n o l o g i e s
Web: http://www.bdt.com.au
Level 5, 1 Southbank Boulevard,
Southbank, Victoria 3006
E-mail: mailto:david.nemirovsky@team.telstra.com
Telephone: (03) 8696 - 5983
Facsimile: (03) 9682 - 7074
Mobile: 04111 - 88 - 44 - 1