SQL/MX 3.1 Programming Manual for C and COBOL (H06.23+, J06.12+)

Contents

HP NonStop SQL/MX Release 3.1 Programming Manual for C and COBOL—663854-001

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