ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-56
NonStop ODBC Server Compared With SQL Server
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, CREATE TABLE differs from the SQL
Server implementation in the following ways:
File Attributes and Security Considerations
The following NonStop SQL/MP file attributes and security considerations apply to the
use of CREATE TABLE:
•
The default physical file attributes for the table are the same as in NonStop
SQL/MP.
•
The default table organization is the same as in NonStop SQL/MP: KEY
SEQUENCED.
•
The table definition must comply with NonStop SQL/MP limits. See the NonStop
SQL/MP Reference Manual for the limits.
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Can CREATE TABLE be
inside a transaction?
No Yes
See DDL Statements Allowed in
User-Defined Transactions on
page 4-3.
Is auditing of the volume
necessary?
N.A. Yes, the volume on which the table is
created must be audited by TMF,
even if the table itself is not audited.
Is the created table
audited?
N.A. Yes, all tables created using the
NonStop ODBC Server are audited
by TMF.
Are user-defined data
types allowed?
Yes No, NonStop SQL/MP does not
support user-defined data types.
How much data can the
table hold?
Depends on the space
allocated for the database
in the CREATE
DATABASE or DISK INIT
statements.
A limited amount set by system
defaults. For information, see the
CREATE TABLE statement in the
NonStop SQL/MP Reference
Manual. To create a table that holds
more data, use pass-through mode.
Should table names be
unique?
Yes, for a specific
database and owner.
Yes, the fully expanded name must
be unique in the network. The
NonStop ODBC Server preserves
uniqueness when the user specifies
and uses a logical name.
Can you name another
user as the owner of the
new table?
No Yes, if the specified owner name is a
valid Guardian logon name.