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));