Generates a data structure used in SELECT statement generation#include <tmusubs.h>int dm_gen_sql_info(int type, char *cursor_name);
- Type of
SELECTto generate, specified by one of these constants:SELECT
- Name of the cursor associated with the SQL statement.
dm_gen_sql_infogenerates a data structure associated with
SELECTstatements. The type is
SELECTwhen the function is called as the result of the transaction commands
VALIDATEwhen the function is called as a result of processing a validation link. The type is
CHECK_PKEYwhen the function is called as a result of checking for duplicate key values before inserting a new row or updating the primary key columns.
int gen_select (cursor)
retcode = dm_gen_sql_info(SELECT, cursor1);