Full text search
function	SQLGetTypeInfo

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the data type information was retrieved). SQL_SUCCESS_WITH_INFO (the data type information was retrieved, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid). SQL_STILL_EXECUTING (the program is still executing).

Declaration

  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