1
Download SQL Users` Manual - ALTIBASE Customer Support
Transcript
SQL Statements Classification SQL statement Description UPDATE Change data in a table. MOVE Moves data from one table to another table. ENQUEUE Insert message into a Queue DEQUEUE Remove message from a Queue Data Control Language(DCL) System Control Statements SQL statement ALTER SYSTEM Description Changes system properties and Check point, Back up the database. Job Control Statements SQL statement ALTER SESSION Description Changes session properties and Controls user transactions. Transaction Control statements SQL statement Description COMMIT Reflects current transaction to the database. ROLLBACKorROLLBACK TO SAVEPOINT savepoint_name Undo the work done; Undo the work done back to the savepoint_name. SAVEPOINT savepoint_name Identifies a point in a transaction to which you can later roll back. SQL Users’ Manual 9
