SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-13
Determining the Organization of the Physical File
Example 5-1. Creating a Table and Dependent Objects (page1of2)
--- DEFINEs were previously added during this SQLCI
--- session or inherited from the command interpreter.
>> INFO DEFINE =MCAT;
DEFINE NAME =MCAT
CLASS CATALOG
SUBVOL \SYS1.$VOL1.MFG
>> INFO DEFINE =ORDERS;
DEFINE NAME =ORDERS
CLASS MAP
FILE $VOL1.MFG.ORDERS
>> INFO DEFINE =REPORDS;
DEFINE NAME =REPORDS
CLASS MAP
FILE $VOL1.MFG.REPORDS
>> INFO DEFINE =XORDCUS;
DEFINE NAME =XORDCUS
CLASS MAP
FILE $VOL2.MFG.XORDCUS
BLOCKSIZE 4096
>> CREATE TABLE =ORDERS
+> (ORDERNUM DECIMAL (6) UNSIGNED NO DEFAULT NOT NULL,
+> ORDER_DATE DATETIME YEAR TO DAY NO DEFAULT NOT NULL,
+> DELIV_DATE DATETIME YEAR TO DAY NO DEFAULT NOT NULL,
+> SALESREP DECIMAL (4) UNSIGNED DEFAULT SYSTEM,
+> CUSTNUM DECIMAL (4) UNSIGNED NO DEFAULT NOT NULL,
+> PRIMARY KEY ORDERNUM)
+> EXTENT (100,100)
+> MAXEXTENTS 24
+> CATALOG =MCAT
+> SECURE “GGOO”;
--- SQL operation complete.
>> CREATE CONSTRAINT DATE_CONSTRNT
+> ON =ORDERS
+> CHECK DELIV_DATE >= ORDER_DATE;
--- SQL operation complete.
>> COMMENT ON TABLE =ORDERS
+> IS “ACTIVE ORDERS TABLE”;
--- SQL operation complete.
>> COMMENT ON COLUMN ORDER_DATE
+> ON =ORDERS
+> IS “FORMAT IS YYMMDD”;
--- SQL operation complete.
>> COMMENT ON COLUMN DELIV_DATE
+> ON =ORDERS
+> IS “FORMAT IS YYMMDD”;
--- SQL operation complete.