We need to use the sp_procxmode in our stored proceudres when we are working with Progress Sonic.

Def

How or change the transaction mode for a stored procedure.

Samples

– all procs
sp_procxmode

– show the mode of a proc
sp_procxmode SPR_SAMPLE

– alter the mode of a proc
sp_procxmode SPR_SAMPLE, ‘anymode’ 

:D



No Responses Yet to “Sybase – sp_procxmode”  

  1. No Comments Yet

Leave a Reply