SQL/MP Programming Manual for COBOL

Introduction

HP NonStop SQL/MP Programming Manual for COBOL—529758-003

1-3

SQL/MP Statements and Directives

Table 1-1. SQL/MP Statements and Directives

Type Statement or Directive

Data Declaration BEGIN DECLARE SECTION and END DECLARE SECTION

INVOKE

INCLUDE STRUCTURES

INCLUDE SQLCA, INCLUDE SQLDA, and INCLUDE SQLSA

Data Definition

Language (DDL)

ALTER CATALOG, ALTER COLLATION, ALTER INDEX, ALTER

PROGRAM, ALTER TABLE, and ALTER VIEW

COMMENT

CREATE CATALOG, CREATE COLLATION, CREATE INDEX,

CREATE PROGRAM, CREATE TABLE, and CREATE VIEW

DROP

HELP TEXT

UPDATE STATISTICS

Data Manipulation

Language (DML)

DECLARE CURSOR

OPEN

FETCH

SELECT, INSERT, UPDATE, DELETE

Data Status

Language (DSL)

GET CATALOG OF SYSTEM

GET VERSION (for SQL/MP software, catalogs, and objects)

GET VERSION OF PROGRAM

Dynamic SQL

Operations

PREPARE

DESCRIBE and DESCRIBE INPUT

EXECUTE and EXECUTE IMMEDIATE

RELEASE

Error Processing WHENEVER

Transaction Control BEGIN WORK, COMMIT WORK, and ROLLBACK WORK