SET
The SET statement allows you to set specific database dependent settings.
General format
EXEC SQL [ AT Database ] SET Options END-EXEC |
Syntax rules
1. No syntax check is performed on the content of Options.
General rules
1. The SET statement is passed as is to the underlying JDBC driver. If the driver doesn’t understand it, an SQL error will be generated.
2. Database identifies the active connection that will execute the query and must be previously defined using a Format 4
DECLARE statement.
Examples
Set the current transaction as READ ONLY and give it a name. This syntax is supported by the Oracle database
exec sql set transaction read only name 'mytran' end-exec |