SQL/MX 2.x Reference Manual (H06.04+)

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-6
PROJECT Table
,jobdesc VARCHAR (18)
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING 'Job Description'
,PRIMARY KEY (jobcode) NOT DROPPABLE
);
PROJECT Table
This statement creates the PROJECT table:
CREATE TABLE samdbcat.persnl.project
( projcode NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Project/Code'
,empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Employee/Number'
,projdesc VARCHAR (18)
DEFAULT 0
NOT NULL NOT DROPPABLE
HEADING 'Project/Description'
,start_date DATE
DEFAULT DATE '2002-07-01'
NOT NULL NOT DROPPABLE
HEADING 'Start/Date'
,ship_timestamp TIMESTAMP
DEFAULT TIMESTAMP '2002-08-01:12:00:00.000000'
NOT NULL NOT DROPPABLE
HEADING 'Timestamp/Shipped'
,est_complete INTERVAL DAY
DEFAULT INTERVAL '30' DAY
NOT NULL NOT DROPPABLE
HEADING 'Estimated/Completion'
,PRIMARY KEY (projcode) NOT DROPPABLE
);
CUSTOMER Table
This statement creates the CUSTOMER table:
CREATE TABLE samdbcat.sales.customer
( custnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Cust/Num'
,custname CHARACTER (18)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Customer Name'
,street CHARACTER (22)
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING
'Street