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.
I am getting this error while doing view data on the source oracle stage of Job 2:
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.
I had tried TO_CHAR and TO_DATE functions but it is not helping.
The strange thing is that the columns are DATE datatype in both datastage jobs and database table but still I am getting this error.
Please help in getting this strange behaviour.
Strange datastage date conversion error.
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: