ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-11
Y2K Implicit Century Conformance
Y2K Implicit Century Conformance
The NonStop ODBC Server supports an implicit century DATE value with the same
semantics as found in NonStop SQL Server. When NonStop ODBC/MP can determine
by context that an input buffer value is a two-digit year value, it prefixes the year value
with a century value of either “00” or “20” before the statement is executed. The prefix
“19” is used if the year value is greater than 50; the prefix “20” is used if the year value
is less than or equal to 50. For example, an input value of “00/01/01” would be
interpreted as “2000/01/01,” while an input value of “99/01/01” would be interpreted as
“1999/01/01.”
Search Conditions
The NonStop ODBC Server supports all search condition syntax except the following:
For detailed information on search conditions, see Search Conditions on page 4-28.
Statements
The SQL statements you can use with the NonStop ODBC Server are a subset of the
SQL Server Transact-SQL statements.
Table B-5 lists the Transact-SQL statements and summarizes how each supported
statement differs when used with the NonStop ODBC Server. If you use an
unsupported statement with the NonStop ODBC Server, an error message is
generated.
WHERE [ NOT ] column-name join-operator column-name
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 1 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
ALTER DATABASE – –
ALTER TABLE x Fully supported.
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), and
the control-of-flow statements are not
supported by the NonStop ODBC Server.
x Indicates that the statement is supported
– Indicates that the statement is not supported