|
|
|
|
|
Linklist | |
SET ISOLATION TO - set the multiuser isolation
SET PDQPRIORITY - set the execution priority
SET LOCK MODE TO - set timeouts
LOAD - load data from a file into a database table
UNLOAD - write data from a database table into a flat file
BEGIN WORK - marks the beginning of an transaction
COMMIT WORK - marks the end of an transaction
ROLLBACK WORK - undo all commands of an transaction
 |
|
SET ISOLATION TO { DIRTY READ | COMMITTED READ | CURSOR STABILITY | REPEATABLE READ };
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 nn;
Sets the priority of the execution 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 nn;
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.
|
|
LOAD FROM Dateiname [ DELIMITER '*' ]
INSERT INTO Tablename
Is used to insert records from a flat file into a database table. The default delimiter in most RDBMS is '|'.
|
|
UNLOAD TO Dateiname [ DELIMITER '*' ] SELECT-Command;
Writes the results of an SELECT statement into an flat file. Each record is written into a new line and the fields are separated with the specifyed delimiter. The default delimiter in most RDBMS is '|'.
|
|
BEGIN WORK;
Marks the begin of an transaction, a set of SQL commands, that can be undo in error case.
|
|
COMMIT WORK;
Marks the end of an transaction, a set of SQL commands, that can be undo in error case.
|
|
ROLLBACK WORK;
Undo all SQL commands of an transaction.