A user or client application can issue set statements to change values that only affect the current client connection. These values remain in effect only for the duration of the client connection or until another set statement is issued.
A client can set values regardless of the SQL transformation mode in effect. However, the set statement must be the only statement in a request. For more information about SQL transformation modes, see “SQL transformation modes”.
DB2 access service set statements are not case sensitive.
To set an DB2 access service configuration property value or processing value for the current connection, issue a set statement in this form:
set { property_name | processing_name } value
where:
property_name is the name of the configuration property.
processing_name is the name of the processing option.
value is a valid value for the configuration property.
For example, the statement set Allocate request sets the Allocate configuration property value to request.