SQL/MP Programming Manual for COBOL85

Contents
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
viii
Index
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-14
Example 2-2. COBOL Record Descriptions Generated by the INVOKE
Directive 2-15
Example 2-3. Creating Valid DATETIME and INTERVAL Data Types 2-20
Example 2-4. Using Host and Indicator Variable Names 2-23
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 6-37
Example 7-1. COBOL CREATEPROCESS Routine 7-3
Example 9-1. Enabling and Disabling the WHENEVER Directive 9-8
Example 9-2. Using the WHENEVER Directive 9-10
Example 9-3. SQLSA Structure 9-22
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
Figures
Figure 1. HP NonStop SQL/MP Library xiv
Figure 2-1. DATE Representation 2-19
Figure 2-2. INTERVAL Representation 2-19
Figure 4-1. Using a Static SQL Cursor in a COBOL Program 4-12