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

Contents

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004

iii

3. Host Variables in C/C++ Programs (continued)

Using Corresponding SQL and C Data Types 3-7

Extended Host Variable Data Types and Generated C Data Types 3-9

Data Conversion 3-11

Specifying Host Variables in SQL Statements 3-12

Using Host Variables in a C/C++ Program 3-13

Character Set Data 3-13

Fixed-Length Character Data 3-14

Variable-Length Character Data 3-16

Numeric Data 3-18

Date-Time and Interval Data 3-23

Host Variables in C Structures 3-28

Host Variables as Data Members of a C++ Class 3-29

Using Indicator Variables in a C/C++ Program 3-29

Inserting Null 3-30

Testing for Null or a Truncated Value 3-30

Retrieving Rows With Nulls 3-31

Creating C Host Variables Using INVOKE 3-31

Using the INVOKE Directive 3-32

INVOKE and Date-Time and Interval Host Variables (SQL/MX Release 1.8

Applications) 3-32

INVOKE and Floating-Point Host Variables 3-33

C Data Types Generated by INVOKE 3-34

Using Indicator Variables With the INVOKE Directive 3-37

C Example of Using INVOKE 3-39

Character Set Examples 3-40

Selecting From a UCS2 Character Set Into a VARCHAR Host Variable 3-41

Fetching From a UCS2 Character Set into a VARCHAR Host Variable

3-41

Selecting From an ISO88591 Character Set Into a UCS2 Host Variable

3-42

4. Host Variables in COBOL Programs

Specifying a Declare Section 4-1

COBOL Host Variable Data Types 4-2

Using Corresponding SQL and COBOL Data Types 4-5

Data Conversion 4-8

Specifying Host Variables in SQL Statements 4-9