SQL/MX 3.2.1 Programming Manual for C and COBOL (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Programming Manual for C and COBOL—663854-005
iii
4. Host Variables in COBOL Programs
Data Conversion 3-13
Specifying Host Variables in SQL Statements 3-15
Using Host Variables in a C/C++ Program 3-16
Character Set Data 3-16
Fixed-Length Character Data 3-17
Variable-Length Character Data 3-19
Numeric Data 3-22
Date-Time and Interval Data 3-33
Host Variables in C Structures 3-39
Host Variables as Data Members of a C++ Class 3-39
Using Indicator Variables in a C/C++ Program 3-40
Inserting Null 3-40
Testing for Null or a Truncated Value 3-41
Retrieving Rows With Nulls 3-41
Creating C Host Variables Using INVOKE 3-42
Using the INVOKE Directive 3-42
INVOKE and Date-Time and Interval Host Variables (SQL/MX Release 1.8
Applications) 3-43
INVOKE and Floating-Point Host Variables 3-44
C Data Types Generated by INVOKE 3-45
Using Indicator Variables With the INVOKE Directive 3-48
C Example of Using INVOKE 3-50
Character Set Examples 3-51
Selecting From a UCS2 Character Set Into a VARCHAR Host Variable 3-52
Fetching From a UCS2 Character Set into a VARCHAR Host Variable 3-52
Selecting From an ISO88591 Character Set Into a UCS2 Host Variable 3-53
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