DB2 10.5 for Linux, UNIX, and Windows

Transferring data in a dynamically executed SQL program using an SQLDA structure

You have greater flexibility when you transfer data using an SQLDA instead of using lists of host variables. For example, you can use an SQLDA to transfer data that has no native host language equivalent, such as DECIMAL data in the C language.

About this task

Use the following table as a cross-reference listing that shows how the numeric values and symbolic names are related.

Table 1. DB2® SQLDA SQL Types
SQL Column Type	SQLTYPE numeric value	SQLTYPE symbolic name¹
`DATE`	384/385	`SQL_TYP_DATE / SQL_TYP_NDATE`
`TIME`	388/389	`SQL_TYP_TIME / SQL_TYP_NTIME`
`TIMESTAMP`	392/393	`SQL_TYP_STAMP / SQL_TYP_NSTAMP`
`n/a`²	400/401	`SQL_TYP_CGSTR / SQL_TYP_NCGSTR`
`BLOB`	404/405	`SQL_TYP_BLOB / SQL_TYP_NBLOB`
`CLOB`	408/409	`SQL_TYP_CLOB / SQL_TYP_NCLOB`
`DBCLOB`	412/413	`SQL_TYP_DBCLOB / SQL_TYP_NDBCLOB`
`VARCHAR`	448/449	`SQL_TYP_VARCHAR / SQL_TYP_NVARCHAR`
`CHAR`	452/453	`SQL_TYP_CHAR / SQL_TYP_NCHAR`
`LONG VARCHAR`	456/457	`SQL_TYP_LONG / SQL_TYP_NLONG`
`n/a`³	460/461	`SQL_TYP_CSTR / SQL_TYP_NCSTR`
`VARGRAPHIC`	464/465	`SQL_TYP_VARGRAPH / SQL_TYP_NVARGRAPH`
`GRAPHIC`	468/469	`SQL_TYP_GRAPHIC / SQL_TYP_NGRAPHIC`
`LONG VARGRAPHIC`	472/473	`SQL_TYP_LONGRAPH / SQL_TYP_NLONGRAPH`
`FLOAT`	480/481	`SQL_TYP_FLOAT / SQL_TYP_NFLOAT`
`REAL`⁴	480/481	`SQL_TYP_FLOAT / SQL_TYP_NFLOAT`
`DECIMAL`⁵	484/485	`SQL_TYP_DECIMAL / SQL_TYP_DECIMAL`
`INTEGER`	496/497	`SQL_TYP_INTEGER / SQL_TYP_NINTEGER`
`SMALLINT`	500/501	`SQL_TYP_SMALL / SQL_TYP_NSMALL`
`n/a`	804/805	`SQL_TYP_BLOB_FILE / SQL_TYPE_NBLOB_FILE`
`n/a`	808/809	`SQL_TYP_CLOB_FILE / SQL_TYPE_NCLOB_FILE`
`n/a`	812/813	`SQL_TYP_DBCLOB_FILE / SQL_TYPE_NDBCLOB_FILE`
`n/a`	960/961	`SQL_TYP_BLOB_LOCATOR / SQL_TYP_NBLOB_LOCATOR`
`n/a`	964/965	`SQL_TYP_CLOB_LOCATOR / SQL_TYP_NCLOB_LOCATOR`
`n/a`	968/969	`SQL_TYP_DBCLOB_LOCATOR / SQL_TYP_NDBCLOB_LOCATOR`
`XML`	988/989	`SQL_TYP_XML / SQL_TYP_XML`
Note: These defined types can be found in the `sql.h` include file located in the `include` sub-directory of the `sqllib` directory. (For example, `sqllib/include/sql.h` for the C programming language.) For the COBOL programming language, the SQLTYPE name does not use underscore (`_`) but uses a hyphen (`-`) instead. This is a null-terminated graphic string. This is a null-terminated character string. The difference between REAL and DOUBLE in the SQLDA is the length value (4 or 8). Precision is in the first byte. Scale is in the second byte.