Hello,
does there a exists a sysprocedure which shows all dbprocedures that are in
use?
i need it to avoid that user can start same process at same time via
webinterface.

best regards.

connection_property('CurrentProcedure') might do what you want. You would
need to call this for each active connection. Something like:
if exists (select * from sa_conn_info()
where
connection_property('CurrentProcedure',number)='<m y procedure>') then
// another connection is using the procedure
end if
This would only work if the procedure does not have nested calls. A more
reliable method of serialization (and also more expensive if frequently
called) would involve updating a table at entry to the procedure.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

"Torsten Brinkmann" <t.brinkmann (AT) svs_ungueltig (DOT) de> wrote