Reject rows from a OCI stage to a sequential file.

rajanikc · Post by **rajanikc** » Wed Mar 12, 2008 2:55 pm

Hi;
I am loading some data from a sequential file to a OCI stage. I have also placed a reject file from the output of the OCI stage. I want to collect all the the records rejected by OCI stage into the reject file.
The problem is for some errors like ORA-12899: value too large for column the job itself is failing istead of the rejected row going into the reject file. So is there any way to capture the row into the reject file with out the job getting aborted?
Thanks in advance.
Rajani

kumar_s · Post by **kumar_s** » Wed Mar 12, 2008 4:57 pm

If the Sequential file or any stages before Oracle stage like Transformer has been defined with proper metadata, the large value data wont even hit the Database. You could have captured the error data in Datastage it self.