'SET CHAINED OFF' - Sybase Warning/Error
Posted: Thu May 14, 2009 8:03 am
Hi,
My job design is as below
Sybase stage -->Transformer-->Sequential file
The sybase stage calls a stored procedure and populates the sequential file. The SP runs fine when run from sybase interface. But when calling the same SP from the datastage job, I get the below error.
"EBCOBirthdaycardsJob..syb_EBCOBdaycards: Sybase Server warning 7713 (severity 16): Stored procedure 'EXTSP_MENT_NEWMEM_BDAY_OUT' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode."
EBCOBirthdaycardsJob..syb_EBCOBdaycards: ct_results has fetched an error
SQL statement: exec EXTSP_MENT_NEWMEM_BDAY_OUT 'N', '04/05/2008', '0100'
I tried changing the statement to 'SET CHAINED ON', still it fails.
My job design is as below
Sybase stage -->Transformer-->Sequential file
The sybase stage calls a stored procedure and populates the sequential file. The SP runs fine when run from sybase interface. But when calling the same SP from the datastage job, I get the below error.
"EBCOBirthdaycardsJob..syb_EBCOBdaycards: Sybase Server warning 7713 (severity 16): Stored procedure 'EXTSP_MENT_NEWMEM_BDAY_OUT' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode."
EBCOBirthdaycardsJob..syb_EBCOBdaycards: ct_results has fetched an error
SQL statement: exec EXTSP_MENT_NEWMEM_BDAY_OUT 'N', '04/05/2008', '0100'
I tried changing the statement to 'SET CHAINED ON', still it fails.