DSXchange

Hi all,

I am trying to transform the data from text file to ORACLE10g database, its simple transformation, no manipulation is done. I am using SEQ->TRF->ODBC stages to do this. I am enabling create table in ODBC Stage. Its creates the DATE datatype for DATE FIELDS. If I am creating the Oracle table with TIMESTAM datatype for Date fields also , The following error occurs



TESTY..xxxxxxxxxxx_Trf.Lnk_Trg_xxxxxxxxxx: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO xxxxxxxx.TESTX("Region", "Location", "CSCCode", "AgentCode", "Distribution", DOJ, "MST_Name", "Policy_No", WRP, "Issuedate", "Proposal_Date", "CNT_Type", CLNTNUM, CLNTNAME, "Month") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=22008, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Datetime field overflow. Error in parameter 6.

Region = "xxxxxxxxxx"
Location = "xxxxxxxxx"
CSCCode = "xxxxx"
AgentCode = "xxxxxxxx"
Distribution = "xxxxxxxxxxx"
DOJ = "28/3/2006 0:00:00"
MST_Name = "xxxxxxxxxx"
Policy_No = "xxxxxxxx"
WRP = xxx
Issuedate = "11/4/2008 0:00:00"
Proposal_Date = "5/4/2008 0:00:00"
CNT_Type = "xxxx"
CLNTNUM = "xxxxx"
CLNTNAME = "xxxxxxxx"
Month = "April08"

I had seen the earlier post, but I want to resolve the issue

Suggestions are most welcome

Thanks in Advance

Date (except within Oracle) is not the same thing as Timestamp. The ODBC driver enforces this difference. Turn your date into a timestamp using appropriate Transform (TIMESTAMP).