SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-74
Statements
ALTER PROGRAM Statement Renames or alters security of an 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
CREATE TABLE Statement
Creates a base table
CREATE VIEW Statement
Creates a view
DECLARE CURSOR Statement
*
Defines a cursor
DELETE Statement
Deletes rows from a table or view
DESCRIBE Statement
* Returns information about output variables of prepared
statements
Table S-3. Summary of SQL Statements
Command Action
* Can be used only in program