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

Host Variables in C/C++ Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
3-35
C Data Types Generated by INVOKE
Example 3-1 shows the CREATE TABLE statement that generates the SQLCDATA
table.
Example 3-1. CREATE TABLE Statement
CREATE TABLE samdbcat.mysch.sqlcdata (
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_float_15 FLOAT (15) NOT NULL,
type_float_30 FLOAT (30) NOT NULL,
type_real REAL NOT NULL,
type_dbl_prec DOUBLE PRECISION NOT NULL,
type_date DATE NOT NULL,
type_time_6 TIME NOT NULL,
type_timestamp_6 TIMESTAMP NOT NULL,
type_interval INTERVAL YEAR TO MONTH NOT NULL
) ;