SQL/MX Programming Manual for C and COBOL (H06.10+, J06.03+)

Contents

HP NonStop SQL/MX Programming Manual for C and COBOL—544617-003

xii

A. C Sample Programs (continued)

Using Argument Lists in Dynamic SQL A-5

Using SQL Descriptor Areas in Dynamic SQL A-7

Using SQL Descriptor Areas With DESCRIBE A-7

Using SQL Descriptor Areas Without DESCRIBE A-12

Using a Dynamic SQL Cursor A-15

Using a Dynamic SQL Cursor With Descriptor Area A-17

Using a Dynamic SQL Rowset A-26

Using SQL Descriptors to Select KANJI and KSC5601 Data A-28

DDL for KANJI and KSC4501 Table Columns A-28

Using SQL Descriptor Areas to Select SQL/MP KANJI and KSC5601 Data A-29

Using SQL Descriptors to Select UCS2 Data A-35

B. C++ Sample Program

Ensuring Data Consistency B-1

C. COBOL Sample Programs

Using a Static SQL Cursor C-1

Ensuring Data Consistency C-4

Using Argument Lists in Dynamic SQL C-6

Using SQL Descriptor Areas in Dynamic SQL C-9

Using a Dynamic SQL Cursor C-13

Index

Examples

Example 2-1. Static and Dynamic SQL and CONTROL Scope 2-14

Example 3-1. CREATE TABLE Statement 3-35

Example 3-2. C Structure Generated by INVOKE 3-36

Example 3-3. C INVOKE 3-39

Example 4-1. Null Test Example 4-21

Example 4-2. CREATE TABLE Statement 4-24

Example 4-3. COBOL Record Description Generated by INVOKE 4-25

Example 4-4. INVOKE Example 4-30

Example 10-1. C VARIABLE_POINTER Example 10-9

Example A-1. Using a Static SQL Cursor A-1

Example A-2. Using TMF to Ensure Data Consistency A-4

Example A-3. Using Argument Lists in Dynamic SQL A-5

Example A-4. Using SQL Descriptor Areas With DESCRIBE A-8