Hi
I am trying to run a stored procedure with input from a sequential file
when I call the stored procedure with transaction size 0 I get teh following error
ExecACCTPlanProcedure,0: Error: Deadlock detected: all input links blocked
But when I give it something other than 0 I get an error:
Stored procedure 'stp_pro' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
Is it in error of stored procedure or am I doing some something else wrong.
Error in stored procedure
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Datastage turns on CHAINED mode (implicit transactions). If you have transaction logic in your procedure than I believe you could run 'SET CHAINED OFF' using the pre SQL. It would probably be better to set the procedure to either chained or anymode. With anymode you should be able to execute the procedure from a session in either chained or unchained mode.
sp_procxmode "procedure", "chained"
OR
sp_procxmode "procedure", "anymode"
I believe this is an issue with datastage's documentation. Or should say, the lack of documentation.
Thanks,
Ryan Putnam
sp_procxmode "procedure", "chained"
OR
sp_procxmode "procedure", "anymode"
I believe this is an issue with datastage's documentation. Or should say, the lack of documentation.
Thanks,
Ryan Putnam
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
Hi
Does any body have an idea what this error is
Stored_Procedure_4,0: Error: Sybase datatype not presently supported
I am trying to call the stored procedure which takes start date an d end date as input using
sel_fls_DSS_extract @begin_datetime = 'MAY-08-2006 09:30:00AM' ,@end_datetime = 'MAY 08 2006 10:00:00'
Thanks
Arif
Does any body have an idea what this error is
Stored_Procedure_4,0: Error: Sybase datatype not presently supported
I am trying to call the stored procedure which takes start date an d end date as input using
sel_fls_DSS_extract @begin_datetime = 'MAY-08-2006 09:30:00AM' ,@end_datetime = 'MAY 08 2006 10:00:00'
Thanks
Arif