Error in stored procedure

[mab_arif16]

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.

[chulett]

How about some details... like what database you are dealing with and what the stored procedure is doing, plus anything else relevant you'd care to share.

[mab_arif16]

The database is sybase ,stored procedure takes input parameters start_date and end_date from sequential file ,and runs the stored procedure for each input.

[chulett]

Don't you already have a thread on this issue?

Sorry, don't know beans about Sybase... and your problem seems specific to that database.

[Ultramundane]

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

[mab_arif16]

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