Conversion from type "timestamp" to type "dat
Moderators: chulett, rschirm, roy
Conversion from type "timestamp" to type "dat
In Job1, I am getting a column CREATED_DT in an oracle table populated with current date using datastage date function CurrentDate().This column is having DATE datatype.
In Job2, this column CREATED_DT from the table which got loaded in Job1 is mapped to another column CREATED_DT in a different table having DATE as datatype.
While running the job,I am getting the following error:
Oracle_Enterprise_0: Error when checking operator: When binding output interface field "CREATED_DT" to field "CREATED_DT": No default type conversion from type "timestamp" to type "date".
Please let me know how to fix this error.
In Job2, this column CREATED_DT from the table which got loaded in Job1 is mapped to another column CREATED_DT in a different table having DATE as datatype.
While running the job,I am getting the following error:
Oracle_Enterprise_0: Error when checking operator: When binding output interface field "CREATED_DT" to field "CREATED_DT": No default type conversion from type "timestamp" to type "date".
Please let me know how to fix this error.
Re: Conversion from type "timestamp" to type "
you can you to_char in select to have a specific format or you can check the type conversion function in tfm.
DS User
DS User
When I changed the source query for the column to:
TO_CHAR(CREATE_DT,'MM/DD/YYYY')
then I am getting this error:
>##E IIS-DSEE-TFIP-00011 17:39:34(001) <Oracle_Enterprise_0> Error when checking operator: When binding output interface field "CREATE_DT" to field "CREATE_DT": No default type conversion from type "string[max=75]" to type "date".
Please help if there is any other solution.
TO_CHAR(CREATE_DT,'MM/DD/YYYY')
then I am getting this error:
>##E IIS-DSEE-TFIP-00011 17:39:34(001) <Oracle_Enterprise_0> Error when checking operator: When binding output interface field "CREATE_DT" to field "CREATE_DT": No default type conversion from type "string[max=75]" to type "date".
Please help if there is any other solution.
-
- Participant
- Posts: 24
- Joined: Thu Aug 12, 2010 11:22 pm
- Location: Bangalore
Re: Conversion from type "timestamp" to type "
Saraswathi: you said you populated current date value to a date field and the same date field you're mapping to another date field in second job. since you are mapping date field to date field you should not get this error. check in job from source side to target side whether it is populating as date only till end. also check the lenght of this field. it should be same everywhere.
ROHIT K A
Conversion from type "timestamp" to type "dat
I am getting this error even after using StringToDate function:
This below error is from the oracle stage:
Oracle_Enterprise_0: Error when checking operator: When binding output interface field "DW_CREATE_DT" to field "DW_CREATE_DT": No default type conversion from type "string[max=75]" to type "date".
As mentioned earlier,I populated current date value using function CurrentDate() in transformer to a date field and the same date field I am mapping to another date field in second job.Since both are mapping date field to date field there should not be an error.
It is really strange.
Can anyone take a look on it?
This below error is from the oracle stage:
Oracle_Enterprise_0: Error when checking operator: When binding output interface field "DW_CREATE_DT" to field "DW_CREATE_DT": No default type conversion from type "string[max=75]" to type "date".
As mentioned earlier,I populated current date value using function CurrentDate() in transformer to a date field and the same date field I am mapping to another date field in second job.Since both are mapping date field to date field there should not be an error.
It is really strange.
Can anyone take a look on it?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Conversion from type "timestamp" to type "
Of course. Your official support provider can. That's what you're paying them to do.saraswati wrote:Can anyone take a look on it?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.