Data types and data conversion in Db2 for i CLI functions
The table shows all of the supported SQL types and their
corresponding symbolic names. The symbolic names are used in
SQLBindParam()
, SQLBindParameter()
, SQLSetParam()
, SQLBindCol()
,
and SQLGetData()
to indicate the data types of the
arguments.
Each column is described as follows:
- SQL type
- This column contains the SQL data type as it appears in an SQL statement. The SQL data types are dependent on the Database Management System (DBMS).
- SQL symbolic
- This column contains an SQL symbolic name that is defined (in
sqlcli.h
) as an integer value. This value is used by various functions to identify an SQL data type in the first column.
SQL type | SQL symbolic |
---|---|
BIGINT | SQL_BIGINT |
BINARY | SQL_BINARY |
BLOB | SQL_BLOB |
CHAR | SQL_CHAR, SQL_WCHAR1 |
CLOB | SQL_CLOB |
DATE | SQL_DATE |
DBCLOB | SQL_DBCLOB |
DECFLOAT(7)2 | SQL_DECFLOAT |
DECFLOAT(16) | SQL_DECFLOAT |
DECFLOAT(34) | SQL_DECFLOAT |
DECIMAL | SQL_DECIMAL |
DOUBLE | SQL_DOUBLE |
FLOAT | SQL_FLOAT |
GRAPHIC | SQL_GRAPHIC |
INTEGER | SQL_INTEGER |
NUMERIC | SQL_NUMERIC |
REAL | SQL_REAL |
SMALLINT | SQL_SMALLINT |
TIME | SQL_TIME |
TIMESTAMP | SQL_TIMESTAMP |
VARBINARY | SQL_VARBINARY |
VARCHAR | SQL_VARCHAR, SQL_WVARCHAR1 |
VARGRAPHIC | SQL_VARGRAPHIC |
XML | SQL_XML |
|