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:

Reference: Precedence of the SET Command

If you issue more than one SET command for the same parameter, the precedence is as follows:


  1. SET in a stored procedure.
  2. SET in the site.wfs or ibidir.wfs file.
  3. SET in a profile on the WebFOCUS Reporting Server.
    1. In a global profile.
    2. In a group profile.
    3. In a user profile.