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
Attempted WRITE with NULL record ID
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 67
- Joined: Thu Apr 06, 2006 7:13 am
Attempted WRITE with NULL record ID
Bhaskar Jha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If the source is a text file, use the format tab or individual column properties to change the representation of NULL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.