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

Host Variables in COBOL Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
4-5
Using Corresponding SQL and COBOL Data Types
PIC[TURE] 9(l-s)V9(s) DISPLAY
specifies the data type of a target host variable for a column of one of these SQL
data types:
DECIMAL (l, s) UNSIGNED
PIC[TURE] 9(l-s) V9(s) DISPLAY
For the corresponding SQL and COBOL host variable data types, see Table 4-1.
Using Corresponding SQL and COBOL Data
Types
Table 4-1 lists the embedded SQL COBOL host variable “a[100]” with all its legal
SQL/MX modifiers, the equivalent data type in NonStop SQL/MX, and the translated
COBOL declarations.
l length; number of digits in the column value
s scale of the column value
l-s number of digits in the integral part of the column value
Table 4-1. COBOL Character Host Variables and Their SQL Data Type
Equivalents and COBOL Translations (page1of2)
COBOL Host Variable
SQL/MX
Equivalent
Data Type Translated COBOL Declaration
A PIC X(100)
A PIC X (100 CHARACTERS)
CHAR(100)
CHARACTER
SET
ISO88591
A PIC X(100)
A CHARACTER SET IS ISO88591
PIC X(100)
A CHARACTER SET IS 1SO88591
PIC X (100 CHARACTERS)
CHAR(100)
CHARACTER
SET
ISO88591
A PIC X(100)
A CHARACTER SET IS UCS2 PIC
X(100)
A CHARACTER SET IS UCS2 PIC
X(100 CHARACTERS)
CHAR(100)
CHARACTER
SET UCS2
A PIC X(200)
A CHARACTER SET IS KANJI
1
PIC X(100)
A CHARACTER SET IS KANJI
1
PIC X(100 CHARACTERS)
CHAR(100)
CHARACTER
SET KANJI
1
A PIC X(200)
A CHARACTER SET IS KSC5601
1
PIC X(100)
A CHARACTER SET IS KSC5601
1
PIC X(100 CHARACTERS)
CHAR(100)
CHARACTER
SET
KSC5601
1
A PIC X(200)