Running a simple ds job error i am getting

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
parsi_cnu
Charter Member
Charter Member
Posts: 43
Joined: Thu Dec 04, 2003 4:26 pm

Running a simple ds job error i am getting

Post by parsi_cnu »

HI everybody,
when i am running a simple datastage job i am getting this error
DataStage Job 59 Phantom 22061
Program "DSD.StageRun": Line 544, Attempted WRITE with NULL record ID
DataStage Phantom Finished.

since it is running in sequencer when this job success only it has to go to other job. so the job is failed.
can anybody help me.
Target condition is update or insert

Thanks
sri
Amos.Rosmarin
Premium Member
Premium Member
Posts: 385
Joined: Tue Oct 07, 2003 4:55 am

Post by Amos.Rosmarin »

Hash file can not accept null into a key column
use a transformer to cleanse the data before writing


HTH,
Amos
ranga1970
Participant
Posts: 141
Joined: Thu Nov 04, 2004 3:29 pm
Location: Hyderabad

Post by ranga1970 »

Why are you bringing in the null records in key coulms, just filter them in transformer or at your source level?
whats your source?
RRCHINTALA
Post Reply