Fog Creek Software
Discussion Board

checking status of Sybase EXECuted statement

Greetings and salutations, all. I have a Sybase 12.5 stored procedure that EXECutes dynamic SQL statements. How can I check for the status of the executed statement?

Sybase Noob
Tuesday, September 30, 2003

Probably the same way we do it in any other database. Have the procedures update a row in a status table, and you just keep an eye on that value.

In long-running procs, I'll have something like this scattered throughout my code:

UPDATE statustable
SET current_status = 'On step whatever'
WHERE active_proc = 'My current proc'

Troy King
Tuesday, September 30, 2003

*  Recent Topics

*  Fog Creek Home