Programming Guide : 5. Working with a Database : How You Can Access a Database with Standard SQL Statements : How You Can Use Other SQL Statements
 
Share this page                  
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.
For more information about transactions, see How You Can Manage Transactions.
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.