ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-50
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is CREATE CATALOG.
Must the database owner
grant access permission
to other users?
Yes, the owner must grant
permission to other users
before they can access the
database.
No. The catalog uses file-
system security. Any user with
the appropriate security can
access the catalog.
For information on file-system
security, see the Guardian
User’s Guide.
Can you specify the
amount of space to
allocate for the
database?
Yes No, NonStop SQL/MP
allocates space on an as-
needed basis.
The only space initially
allocated is the space for the
NonStop SQL/MP catalog.
Disk space for tables and
other objects is allocated as
you create them and enter
data. If the disk is full,
NonStop SQL/MP generates
an error message.
Are there limits on the
size and number of
objects?
Yes, as follows:
•
32,767 databases per
server
•
2 billion tables per
database
•
250 columns per table
•
1962 bytes per row
Yes, the NonStop SQL/MP
limits are used, which can
affect the size of the database.
See information on limits in
the NonStop SQL/MP
Reference Manual.
Do you need to allocate
space for transaction
logs?
Yes No, the system manager
allocates space on a system-
wide basis.
Is auditing of the volume
necessary?
N.A. The volume on which the
catalog is created must be
audited by TMF.
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server