skip to main content
OpenAccess SDK SQL Engine core methods for .NET : Methods for .NET reference : dam_getColByNameAndType
 

dam_getColByNameAndType

This method returns the column handle for the given column number in and type of the current stored procedure. This method 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 (see Chapter 5 "Schema definition and management" of the OpenAccess SDK SQL Engine Programmer's Guide).
int64 dam_getColByNameAndType(
int64 hstmt,
string wsColName,
int iColType)
 
Table 127: Parameters for dam_getColByNameAndType
Parameter
Type
Description
IN
 
 
hstmt
int64
The statement handle
wsColName
string
The 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
 
 
 
int64
The handle to the specified column. 0 is returned if the column does not exist.