regarding date transformtions

[vijaykumar]

hi,
thanks very much.
i used this transformation, i could valid my transformation and run without errors, but went to director to view the warning message.
Oconv(Iconv(Field(DSLink3.HIREDATE," ",1,1),"D-YMD"),"D/DMY[2,2,4]")

iam getting this warning.
drs18datetransf..Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO "dil233"(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22008, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field overflow.
i changed my o/p column length from 19 to 28. but still iam getting error.
plz help me.

cheers;
vijay

[kumar_s]

What is the value that is getting loaded into table for the column HIREDATE?
You can find this in director or for checking, you can replace the database stage as sequential stage and check the output.

[vijaykumar]

Hi gurus,
thanks very much.
when i connect to sequential file, i can view the data.
dont know whats wrong with ODBC.particularly with the length.
Once again thanks very much.

cheers;
vijay

[chulett]

Sheesh... how did we get this deep into your issue without ever knowing what database you are writting to?

Answer some questions for the record:

1) What is your target database?
2) What stage are you using?
3) Is the stage generating the sql or are you?
4) If the stage is, what is your update action? (If you are, post your sql)
5) What is the datatype of the field HIREDATE in the database?
6) What is the datatype of the field HIREDATE in your job?
7) What is the format of your incoming date field?

I know some of these answers are scattered around here, but some seem to have changed over time so let's get them all answered here and put this to rest. It really shouldn't be this difficult.

[kumar_s]

In addition to Craig's Question, do answer my question as well. What is the format of field HIREDATE value before getting loaded into database?