SQL/MP Programming Manual for C

SQL/MP Sample Database
HP NonStop SQL/MP Programming Manual for C—429847-008
A-4
#pragma SECTION CUSTOMER
/* Record Definition for \SYS1.$VOL1.SALES.CUSTOMER */
/* Definition current at 09:54:03 - 11/10/96 */
struct customer_type {
unsigned short custnum;
char custname[19];
char street[23];
char city[15];
char state[13];
char postcode[11];
char credit[3];
};
#pragma SECTION ORDERS
/* Record Definition for \SYS1.$VOL1.SALES.ORDERS */
/* Definition current at 09:54:05 - 11/10/96 */
struct orders_type {
unsigned long ordernum;
long order_date;
long deliv_date;
unsigned short salesrep;
unsigned short custnum;
};
#pragma SECTION ODETAIL
/* Record Definition for \SYS1.$VOL1.SALES.ODETAIL */
/* Definition current at 09:54:06 - 11/10/96 */
struct odetail_type {
unsigned long ordernum;
unsigned short partnum;
long unit_price; /* scale is 2 */
unsigned long qty_ordered;
};
#pragma SECTION PARTS
/* Record Definition for \SYS1.$VOL1.SALES.PARTS */
/* Definition current at 09:54:08 - 11/10/96 */
struct parts_type {
unsigned short partnum;
char partdesc[19];
long price; /* scale is 2 */
long qty_available;
};
Example A-1. COPYLIB File for Sample Database (page 2 of 3)