ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-57
NonStop ODBC Server Compared With
NonStop SQL/MP
•
The ownership and security of the table affect dependent indexes and views.
These dependencies are discussed in the CREATE VIEW, CREATE INDEX, and
ALTER security statements.
For further information on these NonStop SQL/MP features, see the CREATE TABLE
statement description in the NonStop SQL/MP Reference Manual.
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is CREATE TABLE.
When used through the NonStop ODBC Server, CREATE TABLE differs from the
NonStop SQL/MP implementation in the following ways:
Feature In NonStop SQL/MP
In Programs Used With the NonStop
ODBC Server
Can you specify the
physical location of a
table?
Yes No, a table created using the NonStop
ODBC Server is created in the same
location as the NonStop SQL/MP
catalog in which it is registered, unless
you use the pass-through mode.
Default column attribute NULL NOT NULL
Can you specify default
values for columns?
Yes No
Can you create
partitioned tables?
Yes No
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.
Can you create a table
with a primary key?
Yes No, unless you use pass-through
mode.
Data types available All NonStop SQL/MP
data types
Some NonStop SQL/MP data types.
For information on the data types, see
Language Elements
on page 4-5.
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.