Hp Integrity NonStop H-Series Bedienungsanleitung PDF herunterladen (Seite 40)

Table 7 Behavior of unsigned data types

BehaviorODBC version

UNSIGNED SMALLINT is promoted to SIGNED INT and

UNSIGNED INT is promoted to BIGINT.

2.0

All unsigned data types are promoted to the next signed

type.

3.x, when server data source is configured with

SQL_ATTR_MSACCESS_VERSION flag

Partial DATE or TIME values

To use partial DATE or TIME values as parameters, provide these values through the ODBC/MX

data type returned.

To fetch partial DATE or TIME values, see the mappings in Table 8 (page 40). When you fetch

partial DATE or TIME value character strings, the values are returned as partial even if the driver

returns a full DATE or TIME or TIMESTAMP data type. Default values are returned as a structure (1

for YEAR, MONTH and DAY, and 0 for HOUR, MINUTE, SECOND and FRACTION).

Table 8 SQL/MP to ODBC/MX Date/Time Mappings

ODBC/MX data typeSQL/MP data type

SQL_DATEDATETIME YEAR

SQL_DATEDATETIME YEAR TO MONTH

SQL_DATEDATETIME YEAR TO DAY

SQL_TIMESTAMPDATETIME YEAR TO HOUR

SQL_TIMESTAMPDATETIME YEAR TO MINUTE

SQL_TIMESTAMPDATETIME YEAR TO SECOND

SQL_TIMESTAMPDATETIME YEAR TO FRACTION

SQL_DATEDATETIME MONTH

SQL_DATEDATETIME MONTH TO DAY

SQL_TIMESTAMPDATETIME MONTH TO HOUR

SQL_TIMESTAMPDATETIME MONTH TO MINUTE

SQL_TIMESTAMPDATETIME MONTH TO SECOND

SQL_TIMESTAMPDATETIME MONTH TO FRACTION

SQL_DATEDATETIME DAY

SQL_TIMESTAMPDATETIME DAY TO HOUR

SQL_TIMESTAMPDATETIME DAY TO MINUTE

SQL_TIMESTAMPDATETIME DAY TO SECOND

SQL_TIMESTAMPDATETIME DAY TO FRACTION

SQL_TIMEDATETIME HOUR

SQL_TIMEDATETIME HOUR TO MINUTE

SQL_TIMEDATETIME HOUR TO SECOND

SQL_TIMESTAMPDATETIME HOUR TO FRACTION

SQL_TIMEDATETIME MINUTE

SQL_TIMEDATETIME MINUTE TO SECOND

40 Compatibility and considerations

1 2 ... 35 36 37 38 39 40 41 42 43 44 45 ... 61 62

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Integrity NonStop H-Series Bedienungsanleitung Seite 40

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Computerhardware Hp Integrity NonStop H-Series