Issue Set Statements

Unlike global variable queries, which allow you to view but not change any settings, a user or client application can issue a set statement to change those values that 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.

Access service set statements are not case-sensitive. To set an access service configuration property value or processing value for the current connection:

set { property_name | processing_name } value

where:

property_name is the configuration property.
processing_name is the processing option.
value is a valid value for the configuration property.

Example 1:

A set statement for the Client Interaction property SendWarningMessages:

set SendWarningMessages {no | yes}