Hi,
I have developed a job like ODBC->Transformer->Oracle->ODBC .
Here I have enabled the output rejected records option in Oracle stage and I want insert those records in ODBC table.
1) In source I have taken a column value as NULL which is Primarykey in target table, In this case this record should be rejected and insert into ODBC table. But when I ran this job this record is dropping and giving the warning only and it is not rejecting to insert into ODBC table.
2)Another case is I have taken source column data value as string which is Number in target, In this case also record is dropping and giving the warning only and it is not rejecting to insert into ODBC table.
Please let me know the reasons why the record is dropping and why it is not rejecting. And in which case I can see the rejection records.
Thanks in Advance
Sridhar
reject link in Oracle stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NULL will be dropped because you can not transfer NULL into a not null field in DataStage. And primary key columns are ALWAYS not null. You need to intercept the null farther upstream in your job and direct it into an ODBC table. However, null primary key will not be allowed there either.
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.
-
- Participant
- Posts: 35
- Joined: Tue Feb 13, 2007 5:30 am
reject link in Oracle stage
Thanks your response ray....ray.wurlod wrote:NULL will be dropped because you can not transfer NULL into a not null field in DataStage. And primary key columns are ALWAYS not null. You need to intercept the null farther upstream in your job an ...
Can you tell me in which case we can get the rejected records form reject link.
Regards
Sridhar Sivakoti
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: