ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-3
Unsupported Features
Unsupported Features
As stated in “Notation Conventions,” unsupported SQL Server features are underlined
in this manual. For example, in the following syntax, the ON DEFAULT clause is
unsupported.
Mapping of Table, View, and Index Names
When you create tables, views, and indexes, you specify Transact-SQL identifiers for
the table, view, or index names. The NonStop ODBC Server maps these identifiers to
eight-character Guardian file names. Even though the names are mapped, you refer to
the object by its Transact-SQL name when accessing it using the NonStop ODBC
Server.
You need to be concerned with the name mapping only if you are locating the object in
the NonStop ODBC Server mapping tables. The NonStop ODBC Server maps table,
view, and index names to NonStop SQL/MP simple names as follows:
The table-name for a temporary table begins with a number sign (#). When
temporary tables are mapped, the resulting name always begins with an uppercase U.
DDL Statements Allowed in User-Defined Transactions
SQL Server and NonStop SQL/MP have different rules about which DDL statements
are allowed in user-defined transactions.
Table 4-1 lists the supported DDL statements and indicates whether they are allowed
in user-defined transactions in programs executed using SQL Server and programs
executed using the NonStop ODBC Server.
CREATE DATABASE database-name
ON { DEFAULT) } [ = size ]
{ database-device }
Character Replaced With
Number sign (#) Zero (0)
Dollar sign ($) Zero (0)
Underscore (_) Zero (0)
Leading underscore (_) The letter U (uppercase)
Table 4-1. Statements Allowed in User-Defined Transactions (page 1 of 2)
Statement Allowed in SQL Server Allowed in NonStop ODBC Server
ALTER TABLE – x (if the table is audited)
CREATE DATABASE – x
CREATE INDEX – x