SQLDescribeCol

This function returns the result descriptor information (column name, type, precision) for the indicated column in the result set generated by a SELECT statement.

Syntax :

RETCODE  SQLDescribeCol(hstmt,icol,colName, lenColmaneMax, pcbColName,pfSqlType,pcbColDef,pibScale, pfNullable);

Arguments:

The arguments for SQLDescribeCol are listed in below table.

Type	Name	Description
SQLHSTMT	hStmt	Statement handle
SQLSMALLINT	icol	Column number to be described
SQLCHAR*	colName	Pointer to column name buffer
SQLSMALLINT	lenColmaneMax	Size of colName buffer
SQLSMALLINT*	pcbColName	Bytes available to return for szColName argument Truncation of column name (szColName) to cbColNameMax - 1 bytes occurs
SQLUINTEGER*	pfSqlType	SQL data type of column
SQLINTEGER*	pcbColDef	Precision of column as defined in the database
SQLINTEGER*	pibScale	Scale of column as defined in the database
SQLINTEGER*	pfNullable	This indicates whether NULLS are allowed for this column. SQL_NO_NULLS or SQL_NULLABLE

Page last modified on September 25, 2009, at 12:34 PM