ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-39
Defaults, Rules, and Triggers
Defaults, Rules, and Triggers
The NonStop ODBC Server does not support defaults, rules, or triggers. The
unsupported Transact-SQL statements are:
CREATE DEFAULT
CREATE RULE
CREATE TRIGGER
DROP DEFAULT
DROP RULE
DROP TRIGGER
You can use the NonStop SQL/MP CREATE CONSTRAINT and DROP CONSTRAINT
statements in pass-through mode as a partial alternative to CREATE RULE and DROP
RULE. As an alternative to CREATE DEFAULT, you can use the DEFAULT parameter
on the NonStop SQL/MP CREATE TABLE and ALTER TABLE statements in pass-
through mode.
Table 4-15. NonStop ODBC Server Support of Control-of-Flow Statements
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
BEGIN...END x These statements are fully supported; however, in
SQL Server, BEGIN and END are used primarily
to enclose control-of-flow statements (such as IF,
THEN, ELSE, and WHILE), which are not
supported by the NonStop ODBC Server.
BREAK – –
CONTINUE – –
DECLARE x Some data types are unsupported, and the
NonStop ODBC Server maps some data types to
NonStop SQL/MP data types.
For information on usage differences, see
Variables
on page 4-26.
GOTO – –
IF...ELSE – –
PRINT x Fully supported.
RAISERROR – –
RETURN – –
WAITFOR – –
WHILE – –
x Indicates that the statement is supported
– Indicates that the statement is not supported