SQL/MP Programming Manual for COBOL

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
3-4
Finding Information
Data Declaration Directives
INCLUDE SQLCODEX SQLRM,
COBPM
Enables declaring level-88 items to
check for specified conditions.
INCLUDE SQLDA SQLRM,
COBPM
Generates the SQLDA structure to
receive information about input and
output variables for dynamic SQL
statements.
INCLUDE SQLSA SQLRM,
COBPM
Generates the SQLSA structure to
receive execution statistics about DML
or PREPARE statements.
INVOKE SQLRM,
COBPM
Generates a COBOL record description
of a table or view.
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.
Table 3-1. NonStop SQL/MP Statements and Directives (page 2 of 5)
Statement or Directive Manual* Description
* This statement is documented in one or more of these manuals:
SQLRM
SQL/MP Reference Manual
COBPM SQL/MP Programming Manual for COBOL