NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-73
Summary of SQL Statements
Summary of SQL Statements
ALTER CATALOG
Statement
Alters security for a catalog
ALTER COLLATION
Statement
Renames or alters security for a collation
ALTER INDEX
Statement
Renames, adds, or drops partitions, or alters security or other
attributes of an index
ALTER PROGRAM
Statement
Renames or alters security of a SQL program in a Guardian file
ALTER TABLE
Statement
Renames, alters security or file attributes, or enables or disables
similarity checks for a table. Also adds columns to a table and
adds, drops, or moves partitions of a table.
ALTER VIEW
Statement
Renames, alters security, or enables or disables similarity checks
for a view. Also adds columns to a view.
BEGIN DECLARE
SECTION Directive *
Begins a section in a host program for declaring variables known
to SQL
BEGIN WORK
Statement
Starts a TMF transaction
CLOSE Statement *Closes a cursor
COMMENT Statement Writes a comment about an SQL object to a catalog
COMMIT WORK
Statement
Commits all database changes made during the current TMF
transaction and frees resources
CONTINUE Statement Directs SQL to commit or cancel a DDL operation ready for its
final phase
CONTROL
EXECUTOR Directive
Enables or disables parallel processing of queries
CONTROL QUERY
Directive
Specifies details of plans for queries, including when names are
resolved, whether hash joins are permitted, and whether to
optimize response time for returning few or many rows
CONTROL TABLE
Directive
Specifies performance-related options for accesses to a table or
view, including access path, join method, and many other options
CREATE CATALOG
Statement
Creates a catalog
CREATE COLLATION
Statement
Creates a collation
CREATE
CONSTRAINT
Statement
Creates a constraint for a table
CREATE INDEX
Statement
Creates an index on a base table
* Can be used only in program