skip to main content
Table functions : Processing a query on table functions
 

Processing a query on table functions

The following section describes how a query is processed on table functions.
During a query’s execution, the IP can access the parameters and process rows while the table function is being processed. This processing is same as SELECT processing, and is also supported in cursor-based mode.
Your IP must call the dam_describeTableFunction() function to get the parameter list, parameter count, and other information, such as the table function qualifier and the table function owner of the table function.
The following code snippet illustrates how dam_describeTableFunction() is used to pass the statement handle and obtain the name of the table, parameter list, and number of parameters of a table function.
dam_describeTableFunction(pStmtDA->dam_hstmt, NULL, NULL, NULL, NULL, NULL, &hValExpList, &iArgCount);