MX 2.x)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows—527888-004

5-12

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

Partial Date/Time Values

•

To use partial date/time values as parameters, provide values through the

ODBC/MX data type returned.

•

To fetch partial date/time values follow table SQL/MP to ODBC/MX Date/Time

Mappings on page 5-12. Partial date/time values fetched as character strings are

returned as partial even when the driver returns a full date/time/timestamp data

type. Default values are returned as a structure ( 1 for year/month/day, and 0 for

hour/minute/second/fraction).

SQL/MP Data Types and ODBC/MX Equivalents

Table 5-16. Behavior of Unsigned Data Types

ODBC Version Behavior of Unsigned Data Types

2.0 UNSIGNED SMALLINT promoted to SIGNED INT

UNSIGNED INT promoted to BIGINT

3.0, when server side data source is

configured with

SQL_ATTR_MSACCESS_VERSIO

N flag

All unsigned types are promoted to the next signed

type.

Table 5-17. SQL/MP to ODBC/MX Date/Time Mappings

SQL/MP Data Type ODBC/MX Data Type Returned

DATETIME YEAR SQL_DATE

DATETIME YEAR TO MONTH SQL_DATE

DATETIME YEAR TO DAY SQL_DATE

DATETIME YEAR TO HOUR SQL_TIMESTAMP

DATETIME YEAR TO MINUTE SQL_TIMESTAMP

DATETIME YEAR TO SECOND SQL_TIMESTAMP

DATETIME YEAR TO FRACTION SQL_TIMESTAMP

DATETIME MONTH SQL_DATE

DATETIME MONTH TO DAY SQL_DATE

DATETIME MONTH TO HOUR SQL_TIMESTAMP

DATETIME MONTH TO MINUTE SQL_TIMESTAMP

DATETIME MONTH TO SECOND SQL_TIMESTAMP

DATETIME MONTH TO FRACTION SQL_TIMESTAMP