ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
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