Neoview ODBC Drivers Manual (R2.5)

Extended Numeric Precision Columns
Extended numeric precision columns refer to columns which are defined as either NUMERIC(x,y)
signed, where x > 18, or NUMERIC(x,y) unsigned, where x > 9. The Neoview ODBC drivers
support the following conversions to and from extended numeric precision columns:
• SQL_C_CHAR
• SQL_C_FLOAT
• SQL_C_DOUBLE
Unsigned Data Types
Unsigned data types are treated differently, according to the version of ODBC used, and whether
the SQL_ATTR_MSACCESS_VERSION flag is set.
Table 7-16 Behavior of Unsigned Data Types
Behavior of Unsigned Data TypesODBC Version
UNSIGNED SMALLINT promoted to SIGNED INT
UNSIGNED INT promoted to BIGINT
2.0
All unsigned types are promoted to the next signed type.3.0, when server side data source is configured with
SQL_ATTR_MSACCESS_VERSION flag
Partial Date/Time Values
To use partial date/time values as parameters, provide values through the HP Neoview ODBC
driver data type returned.
Microsoft Escape Clauses
The HP ODBC driver accepts Microsoft escape clauses and translates them into equivalent SQL
clauses.
Table 7-17 Microsoft Escape Clauses
SQL EquivalentMicrosoft Escape Clause
DATE 'date-literal'{ d 'date-literal' }
TIME 'time-literal'{ t 'time-literal' }
TIMESTAMP 'timestamp-literal' 1{ ts 'timestamp-literal' }
join-expression{ oj join-expression }
INTERVAL sign interval-string
interval-qualifier
{ INTERVAL sign interval-string
interval-qualifier }
scalar-function 2{ fn scalar-function }
Supported in current release
{ call procedure-name... }
Not supported in the current release.
{ escape 'escape-character' }
Not supported in the current release.
{ [?=]call procedure-name... }
1. ODBC syntax does not include nested joins, while SQL does. HP Neoview ODBC extends the Microsoft syntax
for an outer join.
2. Functions are controlled by SQLGetInfo. Only SQL native functions are supported.
Stored Procedures
The HP Neoview ODBC driver supports stored procedures, including results sets. Pointer to
cursors and returning codes are not supported.
72 HP Neoview ODBC Drivers Conformance