Datenbanktabellen und Datencluster

Deklaration

TABLES: ...

Datensätze lesen

CLOSE CURSOR ...
FETCH NEXT CURSOR ...
LOOP AT Dictionary-Tabelle
OPEN CURSOR ...
PUT ...
READ TABLE Dictioanry-Tabelle
SELECT ...

Anfügen, Ändern und Löschen

DELETE FROM ...
DELETE Dictionary-Tabelle...
DELETE ... FROM TABLE ...
DELETE ... VERSION ...
INSERT Dictionary-Tabelle ...
INSERT ... FROM TABLE ...
INSERT INTO ...
MODIFY Dictionary-Tabelle ...
MODIFY ... FROM TABLE ...
MODIFY ... VERSION ...
UPDATE ...
UPDATE ... SET ...

Native SQL

EXEC SQL ...
EXIT FROM SQL.

Tabellen für Datencluster

DELETE FROM DATABASE ...
DELETE FROM SHARED BUFFER ...
EXPORT ... TO DATABASE ...
EXPORT ... TO SHARED BUFFER
IMPORT DIRECTORY INTO ...
IMPORT ... FROM DATABASE ...
IMPORT ... FROM SHARED BUFFER

Verbuchung

COMMIT WORK.  
ROLLBACK WORK. 

Datencontext

DEMAND ...
SUPPLY ...