Job does not abort

Rohit_ben · Post by **Rohit_ben** » Thu May 31, 2012 6:25 am

We have a simple job that takes data from Oracle Enterprise stage and populates an SQL server table using ODBC enterprise stage.

Oracle Enterprise -> Transformer -> ODBC Enterprise

We have defined constraints on some of the fields in the SQL Server table. But even if the constraints are not met, the job runs successfully by rejecting the records (if we apply a reject link) or silently dropping them. We want the job to get aborted or at least throw a warning with the SQLCODE, if these constraints are not met.

Any ideas regarding this? Do we have to make any changes in the ODBC Configuration?

We are using DtaaDirect v6.0 drivers.

Rohit_ben · Post by **Rohit_ben** » Sun Jun 03, 2012 11:55 pm

When I use a DRS stage(configured to ODBC) instead of ODBC EE stage, the DataStage throws the exact error message. This means that the driver is retreiving the errors from SQL server.

Should I use a DRS stage instead of ODBC stage? What should be the decision based on?