Date Field Solution?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
jo8712
Participant
Posts: 12
Joined: Tue Nov 04, 2003 7:41 am

Date Field Solution?

Post by jo8712 »

I'm trying to use the DSJobStartDate function to populate an updata date on my table. I'm getting the error, "Value treated as NULL
Attempt to convert String value "2003-12-02" to Date type unsuccessful". Why am I getting this error? How can I fix this.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The date is not in the format required by the target table. You need to massage it so that it is.
Can't give more specific advice until you tell us what the target database is and, ideally, the date picture (for example DD/MM/YYYY) that it expects.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply