returning failed record and feild

enigmatic28 · Post by **enigmatic28** » Tue Feb 19, 2008 3:08 am

Hi,

does datastage 7x have a functionality to return or write to a file the records that failed and the name of the column that failed with out using a transformer in the designer for validation?

lets say I have 1000 records having 10 columns, record number 50 failed in column 5..

can datastage write that in a sequential file or can the director be set to display the said information?

thanks...

ArndW · Post by **ArndW** » Tue Feb 19, 2008 3:23 am

Yes, DataStage PX/EE does this by having the designer put a "reject" link out of the passive output stage. For databases this will contain the SQL error code but in neither case does it explicitly tell you which column caused the reject.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 19, 2008 3:32 am

The log will contain any error message generated by the database server. This may or may not contain the name of a column. It may, for example, contain the name of the constraint that was violated. It's then up to you to examing the column values (also logged) to determine which value(s) caused the problem.

enigmatic28 · Post by **enigmatic28** » Tue Feb 19, 2008 3:34 am

Hi,

Will that also tell what column has made the record fail?

thanks...

ArndW · Post by **ArndW** » Tue Feb 19, 2008 3:35 am

ray.wurlod wrote:...This may or may not contain the name of a column...

enigmatic28 · Post by **enigmatic28** » Tue Feb 19, 2008 6:08 pm

Thanks for all that replied....