Known Issues When Using WebFOCUS Commands

&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 style sheet (.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, and then Parameter Prompting, which is located in the Application Settings folder.