Type mismatch with Oracle database

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Type mismatch with Oracle database

Post by gssr »

I am trying to load a single record:
Error Message:
Type match failure for field TRANSMISSION_DATE; APT Schema has string, dbms has type 12.
RAJ
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Oracle type 12 (see the DUMP command) is date, you are supplying a string. Use StringToDate() to convert your string to a date type.
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

Thank you,
I converted the string to date and its fine now
RAJ
Post Reply