Tables Accessed by the Subroutines

The ReportCaster API subroutines read from and write to an SQL-based (relational) repository that stores distribution and scheduling information.

The following WebFOCUS repository tables are accessed by the API subroutines.

Repository Table

Description

Subroutine Used

BOTADDR

Contains Distribution Lists with descriptive information, such as distribution method and access allowed (public or private).

Maintained by DSTBULK.

BOTDEST

Contains information on the individual members of a Distribution List.

Maintained by DSTBULK and DSTMEM.

BOTPARMS

Contains parameter information. Enables a user to schedule a report to run with certain parameter values.

Read by DSTRUN.

BOTSCHED

Contains scheduling information, including scheduling interval, procedures that are run before a report, and procedures that are run after a report.

Read by DSTRUN to immediately run a report.

BOTTASK

Contains information about each individual Task within a schedule.

Read by DSTRUN at run time to obtain the required authorization information.

BOTPACK

Contains the packet ID, which uniquely identifies each schedule.

Read by DSTRUN at run time to obtain the required authorization information.

BOTTSKEX

Contains user and server-related information pertaining to a specific task, such as the ReportCaster User ID, Execution ID and Password, and Server.

Read by DSTRUN at run time to obtain the required authorization information.


WebFOCUS