Environment variable to check Stored proc call
Posted: Thu May 19, 2016 2:11 am
We have a job which calls a stored Proc using Stored procedure stage.
The stored procedure has some insert statements. We have handled exceptions in the stored proc and any exception is captured in the log table.
When the job is run in dev environment the first insert in the stored proc fails due to NULL value in non-nullable field. Same is captured in the log table.
However when the same job is run in test environment the Stored proc runs successfully. However no data is inserted in any table nor in the log table.
We don't see any SP abort message in the DS logs nor in the Log table.
So we are not clear if the SP call was successful from datastage.
Is there any env variable which we can set which will help us in analyzing if the SP call was being made from Datastage?
The stored procedure has some insert statements. We have handled exceptions in the stored proc and any exception is captured in the log table.
When the job is run in dev environment the first insert in the stored proc fails due to NULL value in non-nullable field. Same is captured in the log table.
However when the same job is run in test environment the Stored proc runs successfully. However no data is inserted in any table nor in the log table.
We don't see any SP abort message in the DS logs nor in the Log table.
So we are not clear if the SP call was successful from datastage.
Is there any env variable which we can set which will help us in analyzing if the SP call was being made from Datastage?