SQLDescribeParam

This function returns the description of a parameter marker associated with a prepared SQL statement.

Syntax :

RETCODE  SQLDescribeParam  ( hstmt , paramNo, datatypePtr, paramSizePtr, decPtr, nullable);

Arguments :

The arguments for SQLDescribeParam are listed in below table.

Type	Name	Description
SQLHSTMT	hstmt	Statement handle
SQLSMALLINT	paramNo	Parameter marker number ordered sequentially in increasing parameter order, starting at 1
SQLUINTEGER*	datatypePtr	Pointer to a buffer in which to return the SQL data type of the parameter.
SQLINTEGER*	paramSizePtr	Pointer to a buffer in which to return the size of the column
SQLSMALLINT*	decPtr	Pointer to a buffer in which to return the number of decimal digits of the column
SQLUINTEGER*	nullable	Pointer to a buffer in which to return a value that indicates whether the parameter allows NULL values. This value is read from the SQL_DESC_NULLABLE field of the implementation parameter descriptor. SQL_NO_NULLS – The parameter does not allow NULL values (this is the default value). SQL_NULLABLE – The parameter allows NULL values. SQL_NULLABLE_UNKNOWN – Cannot determine if the parameter allows NULL values.

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