skip to main content
OpenAccess SDK SQL Engine Core Functions API : Function Reference : dam_getColByNameAndType/ dam_getColByNameAndTypeW
 

dam_getColByNameAndType/ dam_getColByNameAndTypeW

This function returns the column handle for the given column number in and type of the current stored procedure. This function is used to get a column of a specific type as defined in the OA_COLUMNTYPE field of OA_PROCCOLUMNS table of the schema database (refer to "Schema Definition and Management" in the OpenAccess SDK SQL Engine Programmer's Guide).
DAM_HCOL dam_getColByNameAndType(
DAM_HSTMT hstmt,
char * sColName,
int iColType)

DAM_HCOL dam_getColByNameAndTypeW(
DAM_HSTMT hstmt,
OAWCHAR * sColName,
int iColType)
Table 102. Parameters for dam_getColByNameAndType/dam_getColByNameAndTypeW
Parameter
Type
Description
IN
hstmt
DAM_HSTMT
The statement handle.
iColName
char *
OAWCHAR *
Name of the column.
iColType
int
Type of column as defined in the schema.
For stored procedures, iColType parameters can be:
*SQL_PARAM_INPUT
*SQL_RESULT_COL
*SQL_PARAM_OUTPUT
*SQL_RETURN_VALUE
For tables, iColType parameters can be:
*DAM_COL_IN_SCHEMA
*DAM_COL_IN_RESULT
*DAM_COL_IN_CONDITION
*DAM_COL_IN_USE
*DAM_COL_IN_OUTPUT
RETURN
DAM_HCOL
The handle to the specified column. A NULL is returned if the column does not exist.