SQL/MX 3.2 Programming Manual for C and COBOL (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Programming Manual for C and COBOL—663854-002
iii
4. Host Variables in COBOL Programs
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-19
Date-Time and Interval Data 3-28
Host Variables in C Structures 3-34
Host Variables as Data Members of a C++ Class
3-34
Using Indicator Variables in a C/C++ Program
3-35
Inserting Null 3-35
Testing for Null or a Truncated Value 3-35
Retrieving Rows With Nulls 3-36
Creating C Host Variables Using INVOKE 3-37
Using the INVOKE Directive 3-37
INVOKE and Date-Time and Interval Host Variables (SQL/MX Release 1.8
Applications) 3-38
INVOKE and Floating-Point Host Variables 3-39
C Data Types Generated by INVOKE 3-40
Using Indicator Variables With the INVOKE Directive 3-43
C Example of Using INVOKE 3-45
Character Set Examples 3-46
Selecting From a UCS2 Character Set Into a VARCHAR Host Variable 3-47
Fetching From a UCS2 Character Set into a VARCHAR Host Variable
3-47
Selecting From an ISO88591 Character Set Into a UCS2 Host Variable 3-48
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
Using Host Variables in a COBOL Program 4-10
Character Set Data 4-10
Fixed-Length Character Data
4-11
Variable-Length Character Data
4-12
Numeric Data 4-12
Date-Time and Interval Data 4-13