HP NonStop SQL/MP

SQL/MP Sample Database
HP NonStop SQL/MP Programming Manual for C—429847-008
A-5
#pragma SECTION PARTSUPP
/* Record Definition for \SYS1.$VOL1.INVENT.PARTSUPP */
/* Definition current at 09:54:09 - 11/10/96 */
struct partsupp_type {
unsigned short partnum;
unsigned short suppnum;
long partcost; /* scale is 2 */
unsigned long qty_received;
};
/* */
/* Inventory (INVENT) */
/* */
#pragma SECTION SUPPLIER
/* Record Definition for \SYS1.$VOL1.INVENT.SUPPLIER */
/* Definition current at 09:54:11 - 11/10/96 */
struct supplier_type {
unsigned short suppnum;
char suppname[19];
char street[23];
char city[15];
char state[13];
char postcode[11];
};
#pragma SECTION PARTLOC
/* Record Definition for \SYS1.$VOL1.INVENT.PARTLOC */
/* Definition current at 09:54:12 - 11/10/96 */
struct partloc_type {
char loc_code[4];
unsigned short partnum;
long qty_on_hand;
};
#pragma SECTION ERRORS
/* Record Definition for \SYS1.$VOL1.INVENT.ERRORS */
/* Definition current at 09:54:14 - 11/10/96 */
struct errors_type {
long errors_date
long errors_time
long errors_id
short errors_sql
char errors_text1[241];
char errors_text2[241];
};
Example A-1. COPYLIB File for Sample Database (page 3 of 3)