skip to main content
OpenAccess SDK SQL Engine core methods for Java : Exchanging data : dam_getColByNameAndType
 

dam_getColByNameAndType

This method returns the column handle for the type of the current store procedure and the specified column number. Use this method 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).
long dam_getColByNameAndType(
     long   hstmt,
     String wsColName,
     int    iColType)
Table 164. Parameters for dam_getColByNameAndType
Parameter
Type
Description
INPUT
hstmt
long
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
long
The handle to the specified column. 0 is returned if the column does not exist.