ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-42
Creation of Partitioned Tables
Creation of Partitioned Tables
You can create an SQL/MP partitioned table by using a partition overlay template with
the CREATE TABLE statement. For details, see Appendix F, Creating Partitioned
Tables.
CORE SQL Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is CREATE TABLE.
CREATE TABLE in CORE SQL differs from the NonStop SQL/MP implementation in
the following ways:
Feature In NonStop SQL/MP In CORE SQL
Can you specify the
physical location of a table?
Yes No. a table created using the
NonStop ODBC Server resides in
the same location as the NonStop
SQL/MP catalog in which it is
registered, unless the profile
attribute DEFAULT_ LOCATION
names an alternative volume. If it
does, the table is created in that
alternative location, but registered
in the current catalog.
Can you create partitioned
tables?
Yes No, unless you use pass-through
mode.
Can you create nonaudited
tables?
Yes No, all tables created through the
NonStop ODBC Server are
audited. To create a nonaudited
table, use pass-through mode.
Data types available All NonStop SQL/MP
data types
Some NonStop SQL/MP data
types. For information
about the
data types, see Language
Elements on page 3-2.
Can you specify table
attributes?
Yes No, unless you use pass-through
mode. Tables created through the
NonStop ODBC Server use
default NonStop SQL/MP table
attributes.