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). |
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 |