Reference: |
The ReportCaster Servlet API reads from and writes to an SQL-based (relational) repository that stores distribution and scheduling information.
When the WebFOCUS repository is SQL-based, the ReportCaster Servlet API uses JDBC to read from and write to the repository tables. The following image illustrates the communication by the ReportCaster Servlet API to an SQL-based WebFOCUS repository.
The following WebFOCUS repository tables are accessed by the ReportCaster Servlet API:
Repository Table |
Description |
Servlet Used |
---|---|---|
BOTADDR |
Contains Distribution Lists, including information such as the distribution method and the owner of the Distribution List. |
Maintained by DSTDLBULK. Read by DSTDLLIST. |
BOTDEST |
Contains information on the individual members of a Distribution List. |
Maintained by DSTDLBULK and DSTDLMEM. Read by DSTDLLIST. |
BOTPARMS |
Contains parameter information. Enables a user to schedule a report to run with certain parameter values. |
Maintained by DSTSCHED. Read by DSTRUNNOW. |
BOTSCHED |
Contains scheduling information, including scheduling interval, procedures run before a report, and procedures run after a report. |
Maintained by DSTSCHED and DSTACTIVE. Read by DSTRUNNOW to immediately run a report. |
BOTTASK |
Contains information about each individual Task within a schedule. |
Maintained by DSTSCHED. Accessed at run time by DSTRUNNOW. |
BOTPACK |
Contains the packet ID, which uniquely identifies each schedule. |
Maintained by DSTSCHED. Accessed at run time by DSTRUNNOW. |
BOTLOG |
Contains log property information (job description, schedule ID, user IDs, and start and end time of the job). When working with the BOTLOG repository table in the ReportCaster API, the values for the RC_ERROR field are as follows: O - Success 1 - Error 2 - Warning |
Read by DSTLOG. |
BOTLOG2 |
Contains information on the events related to the execution and distribution of a report. Note: The DSTLOG servlet has the ability to delete records in BOTLOG, which then deletes corresponding records in BOTLOG2. |
Read by DSTLOG. |
BOTTSKEX |
Contains user and server-related information pertaining to a specific task such as ReportCaster User ID, Execution ID and Password, and Server. |
Maintained by DSTSCHED. Accessed at run time by DSTRUNNOW. |
BOTADDR |
Contains Distribution Lists, including information such as the distribution method and the owner of the Distribution List. |
Maintained by DSTDLBULK. Read by DSTDLLIST. |
BOTDEST |
Contains information on the individual members of a Distribution List. |
Maintained by DSTDLBULK and DSTDLMEM. Read by DSTDLLIST. |
The following diagram illustrates the ReportCaster Servlet API and the tables they access in the WebFOCUS repository.
WebFOCUS |