SQL/MP Programming Manual for COBOL

Contents
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
viii
E. Writing Pathway Servers (continued)
E. Writing Pathway Servers (continued)
CALL Model: SQL Subprograms E-8
UPDATE Subprogram E-8
INSERT Subprogram E-10
Index
Examples
Example 1-1. Static SQL Statements in a COBOL Program 1-4
Example 1-2. Dynamic SQL Statement in a COBOL Program 1-6
Example 2-1. CREATE TABLE Statements 2-15
Example 2-2. COBOL Record Descriptions Generated by the INVOKE
Directive 2-16
Example 2-3. Creating Valid DATETIME and INTERVAL Data Types 2-21
Example 2-4. Using Host and Indicator Variable Names 2-24
Example 4-1. Using a Column Value to Select Data 4-5
Example 4-2. Declaring a Cursor 4-16
Example 4-3. Using the UPDATE statement 4-21
Example 5-1. Error Processing Using SQLCA_DISPLAY2_ 5-9
Example 5-2. Error Routines in Copy Library 5-10
Example 5-3. Calling the SQLCAGETINFOLIST procedure 5-23
Example 5-4. SQLSADISPLAY Display 5-29
Example 6-1. Sample SQL Compiler Listing of a COBOL Program 6-39
Example 7-1. COBOL CREATEPROCESS Routine 7-4
Example 9-1. Enabling and Disabling the WHENEVER Directive 9-9
Example 9-2.
Using the WHENEVER Directive 9-11
Example 9-3. SQLSA Structure 9-23
Example 10-1.
Evaluating Input Parameter Values 10-25
Example 10-2. Prompting for Input 10-28
Example 10-3.
Displaying Output Column Values 10-34
Example 10-4. Sample Dynamic SQL Program 10-37
Example A-1.
COPYLIB File for Sample Database A-3
Example D-1.
Version 2 SQLDA Structure D-3
Example D-2. Version 1 SQLDA Structure D-6
Example E-1.
PERFORM Model E-2
Example E-2.
CALL Model Main Program E-5
Example E-3.
SQL UPDATE Subprogram E-8
Example E-4.
SQL INSERT Subprogram E-10