Reporting Server > Server Introduction > Profile Commands

Profile Commands

Topics:

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.

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.

Note: The list of commands is available from the Settings button on the Web Console Workspace page. We recommend that you use the Web Console settings panes to add the desired settings to your chosen profiles.

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

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 target DBMS. 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

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

 WebFOCUS

Feedback