DSXchange

Hi All,

I have executed a Job

LooKUp(HashFile)
|
|
Hashfile ----> Transformer -----> HashFile

Is the setup of the Job,

The job is compling and after the execution of the Job, I get the following Warning messages

*************************************************************

Program "JOB.1861650351.DT.1333058567.TRANS1": Line 300, Attempted WRITE with NULL record ID

Program "DSD.UVClose": Line 56, Attempted WRITE with NULL record ID

DataStage Phantom Finished

*************************************************************

Could anybody Please help me with this.

Thanks & Regards
SMK

It means pretty much exactly what it says: You are allowing null key values to be written to your target hash. This is a Bad Thing.

To find out the culprit records you can use constraints in the transformer on key columns. Push all the records with Null Key values to a sequential file and the one with Not Null Key values to the target hash file. This should help you in debugging.

Regards,
Sumit

Thank you for your valuable suggestion,was able to check and rectify the issue.


Have a great day.


Thanks
SMK