HP NonStop SQL/MP

Host Variables
HP NonStop SQL/MP Programming Manual for C—429847-008
2-21
C Structures Generated by the INVOKE Directive
These INVOKE directives are coded in a C source file:
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL INVOKE \newyork.$disk1.sql.typesc1 AS typesc1_struc;
EXEC SQL INVOKE \newyork.$disk2.sql.typesc1 AS typesc2_struc;
EXEC SQL END DECLARE SECTION;
Example 2-3. Structures Generated by the INVOKE Directive (page 1 of 2)
/* Record Definition for table \NEWYORK.$DISK1.SQL.TYPESC1
*/
/* Definition current at 13:52:15 - 8/27/96 */
struct typesc1_type {
char type_char[11];
short type_char_null_i;
char type_char_null[11];
struct {
short len;
char val[11];
} type_varchar;
short type_varchar_null_i;
struct {
short len
char val[11];
} type_varchar_null;
short type_num4_s;
unsigned short type_num4_u;
long type_num9_s; /* scale is 2 */
unsigned long type_num9_u; /* scale is 2 */
long long type_num18_s; /* scale is 2 */
short type_small_s;
unsigned short type_small_u;
long type_int_s;
unsigned long type_int_u;
long long type_large_s;
decimal type_decs[19]; /* scale is 2 */
decimal type_dec_u[10]; /* scale is 2 */
unsigned long type_pic_s;
char type_picx[11];
char type_picx_long[21];
float type_float_15;
double type_float_30;
float type_real;
double type_dbl_prec;
char type_datetime[11];
char type_date[11];