SQL/MP Programming Manual for C

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];