set chained mode off ???

[anil bisht]

Hi
i am using sybase server as my database.
From my EJB i am starting the transaction.(bean managed transaction). and my beans calls the Stored procedures.
But the problem i am getting is it says to set the chained mode off. How can i do it. There is a command in sybase
sp_procxmode <sp name>, "anymode"
but i dont want my sp to be run in anymode. Is there any other way around to solve this problem ??
Regards
Anil