define external counter function SQLGetTypeInfo
     (  read-only SQL_handle_type StatementHandle,
        value counter DataType )

Returns information about data types supported by the data source. The information is returned in the form of an SQL result set. The data types are intended for use in Data Definition Language (DDL) statements.

Important: Applications must use the type names returned in the TYPE_NAME column in ALTER TABLE and CREATE TABLE statements. The SQLGetTypeInfo function may return more than one row with the same value in the DATA_TYPE column.

Input arguments:

1. StatementHandle.
2. DataType. The SQL data type. The following values are allowed:
   • SQL_ALL_TYPES (requests all data types)
   • SQL_UNKNOWN_TYPE
   • SQL_CHAR
   • SQL_NUMERIC
   • SQL_DECIMAL
   • SQL_INTEGER
   • SQL_SMALLINT
   • SQL_FLOAT
   • SQL_REAL
   • SQL_DOUBLE
   • SQL_DATETIME
   • SQL_VARCHAR