MX Release 3.1 (H06.23+, J06.12+)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows for SQL/MX Release 3.1—663858-001

5-10

ODBC Data Types

CONVERT Function

ODBC/MX uses the SQL/MX CAST function to support the ODBC CONVERT function.

The ODBC CONVERT function has the following format:

{ fn CONVERT( value_exp, data_type ) }

The SQL/MX CAST has this format:

CAST( {value_exp | NULL } AS data_type )

SQL/MX translates the CONVERT syntax to the CAST syntax, converting the data type

argument to its equivalent SQL/MX value. For example, if the ODBC data type

parameter for character data is an integer value (SQL_CHAR or 1), the equivalent

SQL/MX data type is a string literal with a value of CHARACTER.

ODBC Data Types

TIMESTAMPADD Not supported

TIMESTAMPDIFF Not supported

WEEK WEEK

Table 5-14. System Functions

ODBC Function SQL/MX Equivalent Function

DATABASE Not supported in this release.

IFNULL Not supported in this release.

USER USER

Table 5-15. ODBC Data Types (page 1 of 3)

ODBC

Data Type

SQL/MX

Data Type

SQL/MP

Data Type

Supported by

ODBC/MX

CHAR(n) CHAR(n) CHAR(n)Yes

VARCHAR(n) VARCHAR(n) * VARCHAR(n)* Yes

LONGVARCHAR VARCHAR(n) VARCHAR(n)Yes

DECIMAL(p,s)DECIMAL(p,s)DECIMAL(p,s)Yes

NUMERIC(p,s)** NUMERIC(p,s)** NUMERIC

(p,s)**

Yes

SMALLINT SMALLINT SMALLINT Yes

INTEGER INTEGER INTEGER Yes

REAL REAL REAL Yes

Table 5-13. Time and Date Functions (page 2 of 2)

ODBC Function SQL/MX Equivalent Function