Known Issues When Using WebFOCUS Commands

The following table lists, describes, and provides solutions for known issues that occur when using certain commands in procedures scheduled using ReportCaster.

Command

Known Issue

Solution

&DATE

The following message appears in the log file when you have a pre-execution procedure that attempts to set the EDAPATH and perform a computation on a field that originated from &DATE:

No report for ReportCaster to
distribute

Use the &YYMD amper variable instead of &DATE.

ON TABLE SUMMARIZE

Is ignored when used with ACROSS and COMPUTE in a TABLE request with multiple verbs.

Do not use this syntax with multiple verbs.

TABLE

MAINTAIN

In SQL Server, do not use a field named USER. USER is a reserved word. TABLE and MAINTAIN commands fail if a field name of USER is referenced.

Change the database field name to USERID.

FORMAT YYM and FORMAT YM

Do not display values on MVS.

Set DATEDISPLAY=ON.

-INCLUDE

Cannot create report output that would result in more than one report to distribute, as ReportCaster can only accept a single answer set.

Use with procedures that HOLD or SAVE output. You can use StyleSheet (.sty), Cascading StyleSheet (.css), or GIF (.gif) files with -INCLUDE.

Use the compound report feature.

-EXIT

-QUIT

Do not use these commands within a procedure you schedule because they terminate the internal session that is executing the scheduled job. When the internal session is terminated during the execution of a scheduled job, the report output may be successfully distributed. However, the log information for the execution of the schedule cannot be processed.

Use Dialogue Manager commands to branch to a label located at the end of your procedure. This enables you to implement your application logic, and permit ReportCaster to both run any post-processing procedures specified and process the log information.

FOC_NONE

ReportCaster does not support Server Procedures that use the FOC_NONE syntax.

Use FOC_NONE only in Managed Reporting procedures that will be scheduled with ReportCaster and the WebFOCUS Client. IBIF_describe_null is set to FOC_NONE. The value is set by clicking WebFOCUS Administration Console Configuration, Client Settings, and then Parameter Prompting.

Note: For more information about these commands, see the Developing Reporting Applications manual.


WebFOCUS