ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-48
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is COMMIT WORK.
The primary difference between NonStop ODBC Server transactions and NonStop
SQL/MP transactions is that in programs used with the NonStop ODBC Server, you
can specify a transaction name. The transaction name is provided primarily for
compatibility with SQL Server and is not meaningful in NonStop SQL/MP (because
transactions cannot be nested in NonStop SQL/MP).
In programs used with the NonStop ODBC Server, you cannot specify the NonStop
SQL/MP AUDIT ONLY clause on the COMMIT TRANSACTION statement; therefore,
all locks are released whenever COMMIT TRANSACTION is used.
CREATE DATABASE
Use CREATE DATABASE to create a new NonStop SQL/MP catalog, customized for
use with the NonStop ODBC Server.
When you create a database using CREATE DATABASE in the NonStop ODBC
Server, the NonStop ODBC Server creates a NonStop SQL/MP catalog and the
appropriate mapping tables for that catalog. For information on customized catalogs,
see Section 7, Managing Customized Catalogs.
The CREATE DATABASE statement has the following syntax:
database-name
is the subvolume in which the NonStop SQL/MP catalog is to be created.
The database-name is a subvolume optionally qualified with a node and volume.
If you omit the node and volume, the database-name is expanded using the
current volume and subvolume.
If the specified subvolume already contains a catalog, the catalog is customized.
ON DEFAULT = size
is not supported. In the NonStop ODBC Server, this clause is ignored. No error
messages are generated.
CREATE DATABASE database-name
[ ON { DEFAULT } [ = size ]
{ database-device }
[ , { DEFAULT } [ = size ] ] ... ]
{ database-device }