DB2 graphic QMF Version 8

What reports show up in the selection list under CICS

When a CICS report is created, two attributes are assigned that determine in which selection lists it will be included.

Environment, defines the environment in which the report can run. Only CICS programs show up in selection lists when using the End User Facility under CICS.

The second attribute is the Report Owner. Users are authorized to use a report (regardless of its Shared Status) if they can set their CURRENT SQLID to the owner of the report. In addition, under CICS a user is authorized to use a report if the Report Owner matches the transaction ID used to invoke the End User Facility. For example, if the End User Facility transaction ID is RAAE, any user authorized to run that transaction can use reports whose Report Owner is T=RAAE.

Based on this description, the following sample SQL statement is used to obtain the reports to display in the selection list:

SELECT ...
FROM Q.REPORTS
WHERE ENVIRONMENT = 'C'
   AND (REPORT_OWNER = CURRENT SQLID
      OR REPORT_OWNER = 'T='||EIBTRANID)

Because Shared Status is ignored for CICS reports, it is recommended that CICS sites register all reports with a Shared Status of no and a Report Owner of the form T=tranid. This forces report list selection to be tied to transaction ID authorization.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004