ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
F-1
F Creating Partitioned Tables
To create partitioned tables, follow these steps:
1. Create a Partition Overlay Specification (POS) template
2. Configure your environment
3. Create tables
Creating POS Templates
A template is composed of one or more NonStop SQL/MP DDL partition specifications.
Each template is terminated using a semicolon (;) in the first column of the next line.
The syntax is the same as defined for SQL/MP partition specifications, as follows:
partition-template-filename
specifies the template file name in the format $volume.SSSSSSSS.FFFFFFFF.
You must include the S and F placeholder characters after the volume name.
The ODBC partition specification is limited to a maximum of 4059 characters,
including those allotted for the SQL statement.
[PRIMARY] KEY (column-list)
PARTITION (partition-definition
[, partition-definition. . .])
;
column-list:
column-name [,column-name . . .]
partition-definition is defined as:
partition-template-filename
[ CATALOG catalog ]
[ PHYSVOL volume-name ]
[ EXTENT { size | ( pri-size [, sec-size ] ) } ]
[ MAXEXTENTS size ]
FIRST KEY { key-value | ( key-value[, key-value ...] ) }