db_mux

Sets the deferred database slave lock if the VORTEXaccelerator is active.

Available in:

Apps (win) Apps (char) Reportwriter RPC Standalone PL
X X X X X

Syntax

void db_mux()

Description

If the VORTEXaccelerator is active, then db_mux() sets the deferred database slave lock flag, which locks the slave to the client on the following database operation. You need to execute a COMMIT/ROLLBACK to free the slave.

Example

Locks the VORTEXaccelerator to the client to prevent a potential deadlock.
db_mux();
ll = list_open("select * from staff for update of id,salary",100);
exec_sql("update staff set salary = salary * .60
               where id = :1",list_curr(ll,0));