SQL Statements

Lists the SQL statements that relate to in-memory row-level versioning.

• ALTER DBSPACE Statement
  Changes the read/write mode, changes the size, or extends an existing dbspace.
• ALTER TABLE Statement
  Modifies a table definition.
• CREATE DBSPACE Statement
  Creates a new dbspace and the associated dbfiles for the IQ main store, cache dbspace, catalog store, or RLV store.
• CREATE TABLE Statement
  Creates a new table in the database or on a remote server.
• DELETE Statement
  Deletes all the rows from the named table that satisfy the search condition. If no WHERE clause is specified, all rows from the named table are deleted.
• DROP Statement
  Removes objects from the database.
• INSERT Statement
  Inserts a single row or a selection of rows, from elsewhere in the current database, into the table. This command can also insert a selection of rows from another database into the table.
• LOAD TABLE Statement
  Imports data into a database table from an external file.
• LOCK TABLE Statement
  Prevents other concurrent transactions from accessing or modifying a table within the specified time.
• TRUNCATE Statement
  Deletes all rows from a table or materialized view without deleting the table definition.
• UPDATE Statement
  Modifies existing rows of a single table, or a view that contains only one table.