ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-40
Miscellaneous Transact-SQL Statements
Miscellaneous Transact-SQL Statements
The NonStop ODBC Server does not support the following Transact-SQL statements:
GRANT
KILL
READTEXT
REVOKE
SETUSER
SHUTDOWN
WRITETEXT
GRANT and REVOKE can be processed and ignored by setting a user profile option.
For the SET statement, only two parameters are supported:
PARSEONLY
TEXTSIZE
SQL statements are divided into the following categories:
•
Control-of-flow statements
•
Data Control Language (DCL) statements
•
Data Definition Language (DDL) statements
•
Data Manipulation Language (DML) statements
•
Transaction management statements
•
Miscellaneous statements
Table 4-16 summarizes the supported Transact-SQL statements by statement type.
Table 4-16. Supported Transact-SQL Statements by Type (page 1 of 2)
Transact-SQL
Statement Description
Corresponding
NonStop SQL/MP
Statement
Control-of-Flow Statements
BEGIN...END Executes the set of statements within the
BEGIN and END statements.
None
DECLARE Defines a local variable. None
PRINT Returns a user-defined message to the
user’s application.
None
DDL Statements
ALTER TABLE Adds new columns to an existing table. ALTER TABLE ADD
COLUMN
CREATE
DATABASE
Creates a new NonStop SQL/MP catalog. CREATE CATALOG