Using data type identifiers

Applications use data type identifiers in two ways: to describe their buffers to the driver, and to retrieve metadata about the result set from the driver. Therefore, they can determine what type of Fortran buffers to use to store the data. Applications call the following f90SQL procedures to perform these tasks:

• f90SQLBindParameter, f90SQLBindCol, and f90SQLGetData to describe the Fortran data type of application buffers.

• f90SQLBindParameter to describe the SQL data type of dynamic parameters.

• f90SQLColAttribute and f90SQLDescribeCol to retrieve the SQL data types of result set columns.

• f90SQLDescribeParameter to retrieve the SQL data types of parameters.

• f90SQLColumns, f90SQLProcedureColumns, and f90SQLSpecialColumns to retrieve the SQL data types of various schema information

• f90SQLGetTypeInfo to retrieve a list of supported data types.

Data type identifiers are stored in the SQL_DESC_CONCISE_TYPE field of a descriptor. The descriptor functions, f90SQLSetDescField and f90SQLSetDescRec, can be used with the appropriate types to perform the tasks previously listed. For more information, see f90SQLSetDescField.