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.