Neoview ODBC Drivers Manual (R2.2 SP1)

Table 5-15 ODBC Data Types (continued)
Supported by HP ODBCSQL Data TypeODBC Data Type
Yes
INTERVAL HOUR(p)INTERVAL HOUR(p)
Yes
INTERVAL MINUTE(p)INTERVAL MINUTE(p)
Yes
INTERVAL SECOND(p)INTERVAL SECOND(p)
Yes
INTERVAL DAY(p) TO HOURINTERVAL DAY(p) TO HOUR
Yes
INTERVAL DAY(p) TO MINUTEINTERVAL DAY(p) TO MINUTE
Yes
INTERVAL DAY(p) TO SECONDINTERVAL DAY(p) TO SECOND
Yes
INTERVAL HOUR(p) TO MINUTEINTERVAL HOUR(p) TO MINUTE
Yes
INTERVAL HOUR(p) TO
SECOND(q)
INTERVAL HOUR(p) TO
SECOND(q)
Yes
INTERVAL MINUTE(p) TO
SECOND(q)
INTERVAL MINUTE(p) TO
SECOND(q)
* The VARCHAR length can be up to 4059 for key-sequenced files or 4070 for entry-sequenced files.
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 5-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 5-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... }
60 HP Neoview ODBC Drivers Conformance