ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-44
NonStop ODBC Server Compared With
NonStop SQL/MP
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is ALTER TABLE ADD COLUMN.
When used through the NonStop ODBC Server, ALTER TABLE differs from the
NonStop SQL/MP implementation in the following ways:
BEGIN...END
Use BEGIN...END to enclose a series of statements.
You can include BEGIN and END in programs used with the NonStop ODBC Server;
however, BEGIN and END are used primarily to enclose control-of-flow statements,
which are not supported by the NonStop ODBC Server.
The BEGIN...END statement has the following syntax:
statement-block
is a series of statements. Statement blocks can be nested (BEGIN...END within
another BEGIN...END).
Examples
The following BEGIN and END statements enclose two INSERT statements:
begin
Feature In NonStop SQL/MP
In Programs Used With the
NonStop ODBC Server
Number of columns you
can add with ALTER
TABLE
One Multiple
Can you specify default
values?
Yes No. You cannot specify a default
value unless you use pass-through
mode.
Is NOT NULL available? Yes No. New columns always allow null
values. You cannot specify the NOT
NULL attribute unless you use pass-
through mode.
Can you alter attributes of
a table or column using
ALTER TABLE?
Yes No. You cannot alter the attributes of
a column unless you use pass-
through mode.
BEGIN
statement-block
END