Data Control Language (DCL)

Data Control Language (or DCL) consists of statements that control security and concurrent access to table data.

• COMMIT

  Instructs the XDB Server to make permanent all data changes resulting from DML statements executed by a transaction.

• CONNECT

  Connects the application process (or user) to a designated XDB Server or DB2 location. This location becomes the current location for the application process or user.

• GRANT (Database Privileges)

  Assigns access privileges to XDB Server users or applications.

• GRANT (Sequence Privileges)

  Grants privileges on a user-defined sequence.

• LOCK TABLE

  Extends XDB Server's automatic record and table level locking functions (in a multi-user system) by acquiring explicit locks on a particular table.

• REVOKE (Database Privileges)

  Cancels access privileges for XDB Server users or applications.

• REVOKE (Sequence Privileges)

  Revokes the privileges on a user-defined sequence.

• ROLLBACK

  Instructs the XDB Server to reverse the effect of any DML commands executed on a database by a transaction. Information recorded in a backward log is used to restore the database to a state existing before the transaction.

• UNLOCK TABLE

  Removes table locks (in a multi-user system) acquired with the LOCK TABLE command.