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-26
COBOL Record Descriptions Generated by INVOKE
When you use the INVOKE directive to generate host variables, the HP COBOL
compiler writes a COBOL data description for each column in the specified table or
view. In some cases, the compiler must convert an SQL column name or data type, as
described in Table 4-5.
02 TYPE-DEC9-U PIC 9(7)V9(2) DISPLAY.
02 TYPE-DEC18-S PIC S9(16)V9(2) DISPLAY SIGN LEADING
SEPARATE.
02 TYPE-PIC4-S PIC S9(2)V9(2) DISPLAY SIGN LEADING
SEPARATE.
02 TYPE-PIC4-U PIC 9(2)V9(2) DISPLAY.
02 TYPE-PIC9-S PIC S9(7)V9(2) DISPLAY SIGN LEADING
SEPARATE.
02 TYPE-PIC9-U PIC 9(7)V9(2) DISPLAY.
02 TYPE-PIC18-S PIC S9(16)V9(2) DISPLAY SIGN LEADING
SEPARATE.
02 TYPE-SMALL-S PIC S9(4) COMP.
02 TYPE-SMALL-U PIC 9(4) COMP.
02 TYPE-SMALL-NULL-I PIC S9(4) COMP.
02 TYPE-SMALL-NULL PIC S9(4) COMP.
02 TYPE-INT-S PIC S9(9) COMP.
02 TYPE-INT-U PIC 9(9) COMP.
02 TYPE-LARGE-S PIC S9(18) COMP.
02 TYPE-DATE PIC X(10).
02 TYPE-TIME-6 PIC X(15).
02 TYPE-TIMESTAMP-6 PIC X(26).
02 TYPE-INTERVAL PIC X(6).
Example 4-3. COBOL Record Description Generated by INVOKE (page 2 of 2)