SQL Programming Manual for TAL

Contents

HP NonStop SQL Programming Manual for TAL—527887-001

3. NonStop SQL Statements and Directives

Embedding SQL Statements and Directives 3-1

Coding Statements and Directives 3-2

Placing Statements and Directives in a Program 3-2

Locating Information About SQL Statements and Directives 3-4

BEGIN DECLARE SECTION and END DECLARE SECTION 3-6

CLOSE 3-7

CONTROL Directives 3-8

DECLARE CURSOR 3-11

DELETE 3-13

DESCRIBE and DESCRIBE INPUT 3-16

DROP 3-17

EXECUTE and EXECUTE IMMEDIATE 3-18

FETCH 3-18

INCLUDE SQLCA, INCLUDE SQLDA, and INCLUDE SQLSA 3-19

INSERT 3-19

INVOKE 3-22

OPEN 3-29

PREPARE 3-30

RELEASE 3-31

SELECT 3-31

SQL 3-35

SQLMEM 3-37

SYMBOLPAGES 3-42

UPDATE 3-42

WHENEVER 3-47

4. System Procedures

Procedure Descriptions 4-2

SQLCADISPLAY 4-2

SQLCAFSCODE 4-7

SQLCAGETINFOLIST 4-8

SQLCATOBUFFER 4-13

SQLGETCATALOGVERSION 4-19

SQLGETOBJECTVERSION 4-19

SQLGETSYSTEMVERSION 4-21

SQLSADISPLAY 4-22