SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-3
Data Manipulation Language (DML) Statements
Data Manipulation Language (DML) Statements
Use these DML statements to delete, insert, select, or update rows in one or more
tables:
GRANT Statement on page 2-197 Grants access privileges for an SQL/MX table, view,
or stored procedure to specified users.
GRANT CREATE CATALOG
Statement on page 2-201
Grants privileges to create a catalog for specified
users.
GRANT CREATE SCHEMA
Statement on page 2-202
Grants privileges to create a schema on a specified
catalog to specified users.
GRANT EXECUTE Statement
on
page 2-203
Grants access privileges for a procedure to specified
users.
GRANT SECURITY_ADMIN
Statement on page 2-205
Grants security administration privileges to
designated users.
INITIALIZE SQL Statement
on
page 2-208
Prepares a local node to run NonStop SQL/MX.
Creates SQL/MX user metadata (UMD) tables,
system metadata, and NonStop MXCS metadata
tables.
REVOKE Statement
on page 2-231 Revokes access privileges for a table or view from
specified users.
REVOKE CREATE CATALOG
Statement on page 2-234
Revokes the privilege to create a catalog from
specified users.
REVOKE CREATE SCHEMA
Statement on page 2-235
Revokes the privilege to create a schema on a
specified catalog to specified users.
REVOKE EXECUTE Statement
on
page 2-236
Revokes access privileges for a procedure to
specified users.
REVOKE SECURITY_ADMIN
Statement on page 2-238
Revokes security administration privileges from
designated users.
SET Statement
on page 2-277 Controls the action of a BEFORE trigger.
SIGNAL SQLSTATE Statement
on
page 2-293
Enables a trigger execution to raise an exception that
causes both the triggered and triggering statements
to fail.
DELETE Statement
on page 2-147 Deletes rows from a table or view.
INSERT Statement
on page 2-209 Inserts data into tables and views.
SELECT Statement
on page 2-242 Retrieves data from tables and views.
SELECT ROW COUNT Statement
on page 2-275
Retrieves the count of rows from the
SQL/MX table.
UPDATE Statement
on page 2-297 Updates values in columns of a table or view.