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.
'SET CHAINED OFF' - Sybase Warning/Error
Moderators: chulett, rschirm, roy
-
subash_raaja
- Participant
- Posts: 1
- Joined: Thu Jan 31, 2008 1:26 pm
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: