Profile Commands

In this section:

The following topics describe commands that you can include in any of the supported server profiles. These commands affect the behavior of the server for the duration of the connected session. You can code additional commands, such as data access commands, in any of the supported server profiles. For more information, see specific adapter topics in the online help.

For more information on the server profile commands, launch the online help using the adjacent question mark (?) icons in the Web Console.


Top of page

x
Profile Command Formats

How to:

Each server command takes one of three possible formats. The syntax and an example of these formats follow. Ensure that you use the correct format for any server command you use.



x
Syntax: How to Use a Direct SET Command

To use a direct SET command

SET command=value 

where:

command

Is the server command.

value

Is the value selected from the available choices.



Example: Using a Direct SET Command
SET SQLENGINE=DB2


x
Syntax: How to Use an SQL Engine SET Command

To use the SQL Engine SET command

ENGINE sqlengine SET command value  

where:

sqlengine

Is the data source. You can omit this parameter value if you previously issued the SET SQLENGINE command.

command

Is the server command.

value

Is the value selected from the available choices.



Example: Using an SQL Engine SET Command
ENGINE SQLORA SET OWNERID EDAUSER


x
Syntax: How to Use an SQL Translator Command

To use an SQL Translator command

SQL
SET command=value 
END

where:

command

Is the SQL Translator command.

value

Is the value selected from the available choices.



Example: Using an SQL Translator Command
SQL
SET APT=OFF
END

iWay Software