ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-53
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is CREATE INDEX.
When used through the NonStop ODBC Server, CREATE INDEX differs from the
NonStop SQL/MP implementation in the following ways:
Can you create a
unique index on a
column that allows null
values?
Yes No
How many columns
can be indexed?
Up to 16 Depends on the length of the index key.
See information about “Limits” in the NonStop
SQL/MP Reference Manual.
Can you index BIT type
columns?
No Yes, but the NonStop ODBC Server maps the
BIT data type to the NonStop SQL/MP
SMALLINT data type.
Can you index TEXT
type columns?
No Yes, but the NonStop ODBC Server maps the
TEXT data type to the NonStop SQL/MP
VARCHAR data type.
Can you create a
clustered index?
Yes No
Should index names be
unique?
Yes, within a
table, but not
within a
database.
Yes, the fully expanded name must be unique
in the network.
Feature In NonStop SQL/MP
In Programs Used With the NonStop
ODBC Server
Can you specify
descending keys?
Yes No, unless you use pass-through mode.
Can you create
partitioned indexes?
Yes No, unless you use pass-through mode.
Can you specify
partition attributes?
Yes No, NonStop SQL/MP defaults are
taken.
Can you specify file
attributes?
Yes No, NonStop SQL/MP defaults are
taken.
Can you specify the
physical location of
the index?
Yes No, unless you use pass-through mode.
You can create an index only on the
subvolume that holds the catalog in
which the index will be registered.
Can you create a
clustered index?
Yes No
Feature In SQL Server
In Programs Used With the NonStop
ODBC Server