Call Level Interface Guide and Reference
The conversion function is supported by DB2 CLI and defined
by ODBC using vendor escape clauses.
Each driver and datasource determines which conversions are valid between
the possible data types. As the driver translates the ODBC syntax into
native syntax it will reject the conversions that are not supported by the
data source, even if the ODBC syntax is valid.
Use the function SQLGetInfo() with the appropriate convert
function masks to determine which conversions are supported by the data
source.
Table 193. Conversion Function
- CONVERT( expr_value, data_type )
-
- data_type indicates the data type of the converted representation
of expr_value, and can be either SQL_CHAR or
SQL_DOUBLE.
- expr_value is the value to convert. It can be of various
types, depending on the conversions supported by the driver and
datasource. Use the function SQLGetInfo() with the
appropriate convert function masks to determine which conversions are
supported by the data source.
(When moving from a v2.1.0 to a v2.1.1 database
you must run the migrate utility to access this function.)
|
| DB2 for
| common server 2.1
|
|
|
|
[ Top of Page | Previous Page | Next Page ]