NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-152
Examples—CREATE TABLE
One row of EMP, with column headings, might appear as follows. The SALARY
column has the default value, and the EMPNAME column is upshifted.
Employee
Number Employee Name Monthly Salary
-------- -------------------------------- --------------
62389 ANNA JONES 3882.50
•
The following example creates a table with a clustering key.
CREATE TABLE PROC.HISTORY (
SYSTEM_ID SMALLINT UNSIGNED,
CPU SMALLINT UNSIGNED,
PIN SMALLINT UNSIGNED,
PROGRAM_FILE_NAME VARCHAR (34)
)
CATALOG \SYS3.$VOL1.SYSCAT
ORGANIZATION KEY SEQUENCED
CLUSTERING KEY ( SYSTEM_ID, CPU, PIN );
•
The following example creates a table with partitions. Suppose table ODETAIL
contains about 5 million rows. Each row has 20 bytes: ORDERNUM, 6;