skip to main content
SQL Engine parse tree methods for Java : damex_getFirstCol
 

damex_getFirstCol

This method navigates through the columns that appear in the SELECT, UPDATE and WHERE clause of the SQL query or through the columns in the schema definition of the table. Call this method with the column types to be navigated and then use the damex_getNextCol method to step through the list.
long damex_getFirstCol(
     long hTable,
     int  iColType)
Table 276. Parameters for damex_getFirstCol
Parameter
Type
Description
INPUT
hTable
long
Table handle.
iColType
int
Identifies the column list to navigate; use a bitwise OR ( | ) of the following flags to scan through columns that are in multiple categories:
DAM_COL_IN_SCHEMA - list of all columns as defined in the schema database.
DAM_COL_IN_RESULT - list of columns that are part of the result set.
DAM_COL_IN_CONDITION - list of columns that are in the WHERE clause.
DAM_COL_IN_UPDATE_VAL_EXP - list of all columns that are part of update value expressions.
DAM_COL_IN_USE - list of columns that are either part of the result or are in the WHERE clause.
RETURN
long
The handle to the first column that has the attributes of iColType. A 0 otherwise.

See also

*damex_getNextCol