The action routines within the .ACT files that DB/Assist generates will vary depending on the type of SQL statement. The following table lists the action routines generated for each type of SQL statement.
Statement Type |
Generated Action Routines |
SELECT (multi-row)
|
OPEN_StatementName FETCH_StatementName CLOSE_StatementName |
SELECT (single row) |
EXECUTE_StatementName |
UPDATE (searched and positioned) |
EXECUTE_StatementName |
DELETE (searched and positioned) |
EXECUTE_StatementName |
INSERT |
EXECUTE_StatementName |
Other |
EXECUTE_StatementName |
