Other SQL commands

Here are some other SQL commands sometimes needed for optimal query execution.

SET ISOLATION TO - set isolation level

Syntax:

    SET ISOLATION TO { DIRTY READ | COMMITTED READ | CURSOR STABILITY | REPEATABLE READ };

Description:

    SET ISOLATION TO DIRTY READ sets the multiuser isolation so, that an SQL-command does not respect locked records, even when they are locked for UPDATE .

SET PDQPRIORITY - set ressource priority

Syntax

Description:

    Sets the priority of granting ressources on the server to nn. The default Value ist 0 (without priority), when no other special settings are made.

    Example:

SET PDQPRIORITY 5;

Sets the priority to 5 (small).

SET LOCK MODE TO WAIT - set timeouts

Syntax:

Description:

    Set the timeout (the time, in which the DBMS waites until records unlocked) to nn seconds.

    Example:

SET LOCK MODE TO WAIT 60;

Sets the timeout to 60 seconds.