Attempted WRITE with NULL record ID

bhaskarjha · Post by **bhaskarjha** » Wed May 10, 2006 4:11 am

Hi

MY JOB IS GETTING ABORTED IN BETWEEN AND GETTING FOLLOWING ERROR , I KNOW THIS TOPIC IS DISCUSS IN THIS FORUM AND THERE MIGHT BE AN NULL VALUE IN ANY OF THE KEY COLUMN , BUT IS THERE ANY WAY THAT I WILL GET THE NAME OF COLUMN AND EXACT FILE FROM WHERE NULL IS COMING

DataStage Job 133 Phantom 3296
Program "JOB.1693180165.DT.1364373690.TRANS2": Line 145, Attempted WRITE with NULL record ID
Program "JOB.1693180165.DT.1364373690.TRANS2": Line 145, Attempted WRITE with NULL record ID
Program "JOB.1693180165.DT.1364373690.TRANS2": Line 145, Attempted WRITE with NULL record ID
Program "JOB.1693180165.DT.1364373690.TRANS2": Line 145, Attempted WRITE with NULL record ID

ArndW · Post by **ArndW** » Wed May 10, 2006 4:24 am

The empty value is in the KEY, you can identify the column of a compound key only by splitting the columns individually, for instance by another output stream to a sequential file that splits out each individual column.

ray.wurlod · Post by **ray.wurlod** » Wed May 10, 2006 2:51 pm

Search your sources WHERE colname IS NULL.
If the source is a text file, use the format tab or individual column properties to change the representation of NULL.