NetBase SQL Shadowing Handbook

NetBase SQL User Exits
____________________________________________________________
ver A0195 QUEST Software, Inc. 3-23
short upd_col_type;
short upd_col_length;
} upd_rec;
typedef struct {
char DBEname [26];
char owner_name [20];
char table_name [20];
char user_name [20];
char commit_time [24];
short record_type;
short num_columns;
short upd_columns;
col_rec column_array [256];
upd_rec update_array [256];
} header_rec;
#pragma list on
EXEC SQL BEGIN DECLARE SECTION;
char SQLMsg[130]; /* Used by SQLExplain */
char tableName[20]; /* Used by various SQL commands */
EXEC SQL END DECLARE SECTION;
/* UTILITY FUNCTIONS */
/* uexit_datetime_convert */
/* */
/* Convert the DATE/TIME/DATETIME data type from the internal */
/* format into ascii. Return a pointer to the ascii string. */
/* */
char *uexit_datetime_convert (byte *data, int type)
{
static char result[40];
struct {
unsigned year :14;
unsigned month :4;
unsigned day :6;
} dt;
struct {
unsigned hour :6;
unsigned minute :6;
unsigned second :6;
} tm;
struct {
unsigned fill :2;
unsigned milli :20;
unsigned filler :2;
} mi;
switch (type) {