Page 1 of 1

DataStage Phantom Warnings

Posted: Thu Feb 08, 2007 3:58 pm
by Mun
Hi all, I am getting these warnings..Anyway to fix this? I've tried reset the job and rerun it.

DataStage Job 765 Phantom 6982
Program "DSD.UVClose": Line 56, Attempted WRITE with NULL record ID
DataStage Phantom Finished

DataStage Job 765 Phantom 6983
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID

Posted: Thu Feb 08, 2007 4:02 pm
by DSguru2B
The message indicates that you are attempting to populate NULL in the key field of a hashed file, which is not allowed and hence the warning.

Posted: Thu Feb 08, 2007 4:04 pm
by Mun
Thanks. I've always thought it was the target table. Let me check the hash files and rerun it again...

DSguru2B wrote:The message indicates that you are attempting to populate NULL in the key field of a hashed file, which is not allowed and hence the warning.