Ways to Issue a SET Command
You can issue a SET command by using the SET tool to
generate the command in the stored procedure, or by coding it in
a stored procedure. If you use the SET tool, a SET command will
be generated for the report you are developing. If you code the SET
command, you have the following options for its placement:
- In a supported
profile on a WebFOCUS Reporting Server. When issued in a profile,
the setting applies to the server environment during the connection
for executing the current procedure.
- In a stored
procedure:
- Before the
report request.
- With ON TABLE
SET or ON GRAPH SET in a report or graph request. SET used in this
manner applies only to the report or graph request in which it is
issued, even though there may be multiple report or graph requests
in the stored procedure.
- In a type Other
reporting object, in the Managed Reporting administrator environment.
A setting issued in a reporting object (type Other) applies to a
single report template.
- In the WebFOCUS
script file site.wfs. When issued in site.wfs, the setting applies to
all connections to the WebFOCUS Reporting Server from the WebFOCUS
Client.
x
Reference: Precedence of the SET Command
If
you issue more than one SET command for the same parameter, the
precedence is as follows:
Developer Studio
- ON TABLE SET
or ON GRAPH SET in a stored procedure.
- SET in a stored
procedure.
WebFOCUS
- SET in a stored
procedure.
- SET in the
site.wfs or ibidir.wfs file.
- SET in a profile
on the WebFOCUS Reporting Server.
- In a global
profile.
- In a group
profile.
- In a user profile.