Data conversion problem

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No 'conversion' required, simply substring off just the date portion:

DSLink5.JOB_EFFECTIVE_DATE[1,10]
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
seshikumar
Participant
Posts: 44
Joined: Fri Mar 16, 2007 5:51 am

Post by seshikumar »

Thanks for your quick response. its work.
seshu
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”