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-24
COBOL Record Descriptions Generated by INVOKE
Example 4-2 shows the CREATE TABLE statement that generates table
SQLCOB_DATA.
Example 4-2. CREATE TABLE Statement
CREATE TABLE SQLCOB_DATA (
type_char CHAR (10) NOT NULL,
type_char_null CHAR (10) ,
type_UCS2_CHAR CHAR(10) CHARACTER SET UCS2 NOT NULL,
type_UCS2_VARCHAR VARCHAR(10) CHARACTER SET UCS2 NOT NULL,
type_picx PIC X(10) NOT NULL,
type_varchar VARCHAR (10) NOT NULL,
type_num4_s NUMERIC (4) SIGNED NOT NULL,
type_num4_u NUMERIC (4) UNSIGNED NOT NULL,
type_num9_s NUMERIC (9,2) SIGNED NOT NULL,
type_num9_u NUMERIC (9,2) UNSIGNED NOT NULL,
type_num18_s NUMERIC (18,2) SIGNED NOT NULL,
type_piccomp4_s PIC S9(2)V9(2) COMP NOT NULL,
type_piccomp4_u PIC 9(2)V9(2) COMP NOT NULL,
type_piccomp9_s PIC S9(7)V9(2) COMP NOT NULL,
type_piccomp9_u PIC 9(7)V9(2) COMP NOT NULL,
type_piccomp18_s PIC S9(16)V9(2) COMP NOT NULL,
type_dec4_s DECIMAL (4) SIGNED NOT NULL,
type_dec4_u DECIMAL (4) UNSIGNED NOT NULL,
type_dec9_s DECIMAL (9,2) SIGNED NOT NULL,
type_dec9_u DECIMAL (9,2) UNSIGNED NOT NULL,
type_dec18_s DECIMAL (18,2) SIGNED NOT NULL,
type_pic4_s PIC S9(2)V9(2) NOT NULL,
type_pic4_u PIC 9(2)V9(2) NOT NULL,
type_pic9_s PIC S9(7)V9(2) NOT NULL,
type_pic9_u PIC 9(7)V9(2) NOT NULL,
type_pic18_s PIC S9(16)V9(2) NOT NULL,
type_small_s SMALLINT SIGNED NOT NULL,
type_small_u SMALLINT UNSIGNED NOT NULL,
type_small_null SMALLINT ,
type_int_s INTEGER SIGNED NOT NULL,
type_int_u INTEGER UNSIGNED NOT NULL,
type_large_s LARGEINT NOT NULL,
type_date DATE NOT NULL,
type_time_6 TIME(6) NOT NULL,
type_timestamp_6 TIMESTAMP(6) NOT NULL,
type_interval INTERVAL YEAR TO MONTH NOT NULL
) ;