SQL Programming Manual for TAL

Host Variables and Parameters
HP NonStop SQL Programming Manual for TAL—527887-001
2-21
Creating Host Variables With the INVOKE Directive
The INVOKE directive as it appears in the source program is:
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL INVOKE typestbl AS types^rec;
EXEC SQL END DECLARE SECTION;
The CREATE TABLE statement that defines the table is:
CREATE TABLE $vol.sales.typestbl
( a_char CHAR (10) NOT NULL,
b_varchar VARCHAR (10) NOT NULL,
c_num4_s NUMERIC (4) SIGNED NOT NULL,
d_num4_u NUMERIC (4) UNSIGNED NOT NULL,
e_num9_s NUMERIC (9,2) SIGNED NOT NULL,
f_num9_u NUMERIC (9,2) UNSIGNED NOT NULL,
g_num18_S NUMERIC (18,2) SIGNED NOT NULL,
h_small_S SMALLINT SIGNED NOT NULL,
j_small_U SMALLINT UNSIGNED NOT NULL,
k_int_s INTEGER SIGNED NOT NULL,
l_int_u INTEGER UNSIGNED NOT NULL,
m_large_s LARGEINT SIGNED NOT NULL,
n_dec_s DECIMAL (18,2) SIGNED NOT NULL,
o_dec_u DECIMAL (9,2) UNSIGNED NOT NULL,
p_cob_p9 PIC 9(9) COMP NOT NULL,
q_cob_px PIC X(10) NOT NULL,
z_long PIC X(20) NOT NULL,
a_dbl FLOAT (15) NOT NULL,
b_dbl FLOAT (30) NOT NULL,
c_dbl REAL NOT NULL,
d_dbl DOUBLE PRECISION NOT NULL,
a_dt_time DATETIME YEAR TO DAY NOT NULL,
b_dt_time DATE NOT NULL,
c_dt_time TIME NOT NULL,
d_dt_time TIMESTAMP NOT NULL,
e_dt_time INTERVAL MONTH(6) NOT NULL
)
CATALOG $vol1.sales ;