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
regarding date transformtions
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
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.
![Confused :?](./images/smilies/icon_confused.gif)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers