SQL/MP Programming Manual for C

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for C—429847-008
3-4
Finding Information
Data Definition Language (DDL) Statements
ALTER CATALOG SQLRM Alters the security attributes of a catalog.
ALTER COLLATION SQLRM Alters the security attributes of a collation;
renames a collation.
ALTER INDEX SQLRM Alters security attributes of indexes; alters
physical file attributes of indexes and
partitions of indexes; adds and drops
partitions; renames indexes and partitions.
ALTER PROGRAM SQLRM Alters security attributes for a program;
renames a program.
ALTER TABLE SQLRM Alters security attributes of tables; alters
physical file attributes of tables and
partitions of tables; alters the HEADING
attribute for columns of tables and views;
adds and drops table partitions; renames
tables and partitions of tables; adds new
columns to tables.
ALTER VIEW SQLRM Alters security attributes for a view or
renames a view.
COMMENT SQLRM Adds a comment to an object definition.
CREATE SQLRM Creates a collation, constraint, catalog,
index, table, or view.
DROP SQLRM Drops a collation, constraint, catalog, index,
program, table, or view.
HELP TEXT SQLRM Specifies help text for a column of a table
or view.
UPDATE STATISTICS SQLRM Updates information about the contents of a
table and its indexes.
Error Checking Directives
WHENEVER SQLRM
SQLPM/C
Generates code that checks SQL statement
execution for errors, warnings, and the not
found condition for rows.
Table 3-1. Summary of SQL/MP Statements and Directives (page 2 of 4)
Statement or Directive Manual * Description
*This statement is documented in one or more of these manuals:
SQLRM SQL/MP Reference Manual
SQLPM/C SQL/MP Programming Manual for C