ODBC Server Reference Manual

Introduction
HP NonStop ODBC Server Reference Manual—429151-002
1-13
Supported and Unsupported SQL Server Features
Transact-SQL
statements
Data Definition Language (DDL)
statements, such as CREATE
DATABASE and DROP TABLE, are
supported.
Data Manipulation Language (DML)
statements, such as SELECT and
UPDATE, are supported.
Transaction management statements,
such as BEGIN TRANSACTION and
COMMIT TRANSACTION, are
supported.
Control-of-flow statements, such as
IF...ELSE, WHILE, and GOTO, are not
supported.
The CREATE and DROP statements
for defaults, procedures, rules, and
triggers are not supported.
GRANT and REVOKE statements are
accepted, but their actions are not
performed.
Section 4, Transact-SQL
Language
Stored procedures Execution of stored procedures is
supported, but the procedures must be
created in the Pathway environment.
Section 5, Stored Procedures
Triggers Triggers are not supported. Not described in this manual
Table 1-7. NonStop ODBC Server Support of SQL Server Features (page 4 of 4)
Feature
Description of NonStop ODBC
Server Support More Information