How You Can Use Other SQL Statements
There are two types of SQL statements that you can code directly in a 4GL script:
• Data definition statements
These include statements that create data structures, such as tables or views, rules, and database events.
All data definition statements participate in transactions. Using one of these statements initiates a transaction if none was open, and any work performed by these statements is affected by the commit and rollback statements.
• Statements that do not access database tables
Two examples of this type are the set statement (including set autocommit and set lockmode) and the inquire_sql statement. The set statements do not take part in transactions and cannot be issued inside them.
For a list of SQL statements and their syntax, see the Language Reference Guide online help.