HP NonStop SQL/MP

Host Variables
HP NonStop SQL/MP Programming Manual for C—429847-008
2-20
C Structures Generated by the INVOKE Directive
Example 2-2. CREATE TABLE Statements
CREATE TABLE \NEWYORK.$DISK1.SQL.TYPESC1 (
type_char CHAR (10) NOT NULL,
type_char_null CHAR (10)
,
type_varchar VARCHAR (10) NOT NULL,
type_varchar_null VARCHAR (10)
,
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_small_s SMALLINT SIGNED NOT NULL,
type_small_u SMALLINT UNSIGNED NOT NULL,
type_int_s INTEGER SIGNED NOT NULL,
type_int_u INTEGER UNSIGNED NOT NULL,
type_large_s LARGEINT SIGNED NOT NULL,
type_decs DECIMAL (18,2) SIGNED NOT NULL,
type_dec_u DECIMAL (9,2) UNSIGNED NOT NULL,
type_pic_s PIC 9(9) COMP NOT NULL,
type_picx PIC X(10) NOT NULL,
type_picx_long PIC XXXXXXXXXXXXXXXXXXXX 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_datetime DATETIME YEAR TO DAY NOT NULL,
type_date DATE NOT NULL,
type_time TIME NOT NULL,
type_timestamp TIMESTAMP NOT NULL,
type_interval INTERVAL YEAR TO MONTH NOT NULL,
type_char_null_ok CHAR(10) DEFAULT NULL,
type_num_null_ok SMALLINT DEFAULT NULL
) CATALOG $SQL.SQLCAT ;
CREATE TABLE \NEWYORK.$DISK1.SQL.TYPESC2 (
type_char1 CHARACTER (10) CHARACTER SET ISO88591 NOT
NULL,
type_char1_null CHARACTER (10) CHARACTER SET ISO88591
,
type_char2 CHARACTER (10) CHARACTER SET KANJI NOT NULL,
type_char2_null CHARACTER (10) CHARACTER SET KANJI
,
type_nchar NCHAR (10) NOT NULL,
type_nchar_v NCHAR VARYING (10) NOT NULL
type_varchar1 VARCHAR (10) CHARACTER SET ISO88591 NOT
NULL,
type_varchar2 VARCHAR (10) CHARACTER SET KANJI NOT NULL,
type_picx1 PIC X(10) CHARACTER SET ISO88591 NOT NULL,
type_picx2 PIC X(10) CHARACTER SET KANJI NOT NULL
) CATALOG $SQL.SQLCAT ;