Phantom Warning

chulett · Post by **chulett** » Mon Apr 23, 2007 10:40 pm

Welcome aboard. :D

Your problem is stated in the error - the solution is to stop sending nulls to the Key field(s) of your hashed file.

arshi · Post by **arshi** » Tue Apr 24, 2007 5:47 am

Hi All,

I am facing following warning while running the job.Job finished but giving the warning.I am using 7.1 version.

-----------
ds_uvput() - Write failed for record id '<Missing or NULL>'

DataStage Job 368 Phantom 2924
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
DataStage Phantom Finished
-----------

Can any one give the solution to overcome this problem

Regards,
Arshi

arshi · Post by **arshi** » Fri Apr 27, 2007 4:25 am

how to stop the nulls for the next level?
In my ODBC given column is the key column and I given the nullable column as NO.

Is this to over come my problem
?

DSguru2B · Post by **DSguru2B** » Fri Apr 27, 2007 7:10 am

If you specify it as not null in datastage but its a nullable column in the database, it wont help. Explicitly use the IsNull() function to check for nullability and either reject the record or specify a default value.

chulett · Post by **chulett** » Fri Apr 27, 2007 7:14 am

Make sure you've got a Transformer between the two and use a constraint to stop the nulls.