Examples: INCLUDE and EXCLUDE sensitivity

The following report examples show how slight variations to SELECT statements can change report content.
  1. This command generates a Performance Summary report for all records except those with terminal TM01.
    CICSPA IN(SMFIN001),
           SELECT(PERFORMANCE(EXCLUDE(TERM(TM01)))),
           SUMMARY
  2. This command generates a Performance Summary report with data from performance class records for terminals TM01 and TM02.
    CICSPA IN(SMFIN003),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM01)))),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM02)))),
           SUMMARY

    The two SELECT statements could have been combined as SELECT(PERFORMANCE(INCLUDE(TERM(TM01,TM02)))). However, this command shows a method that can be used if more values need to be listed than CICS PA will allow for one character field.

    Be careful, as all selection criteria stay in effect when specifying more than one SELECT statement for a single field.

    The following command generates a Performance Summary report for only transaction XXXX on terminal TM01 and for all transactions on terminal TM02.
    CICSPA IN(SMFIN004),
           SELECT(PERFORMANCE(INCLUDE(TRAN(XXXX),
                                      TERM(TM01)))),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM02)))),
           SUMMARY
    The following command generates a Performance Summary report for transaction XXXX on all terminals, and all other transactions on terminals TM01 and TM02.
    CICSPA IN(SMFIN004),
           SELECT(PERFORMANCE(INCLUDE(TRAN(XXXX)))),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM01)))),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM02)))),
           SUMMARY
    The following command generates a Performance Summary report for transaction XXXX on terminals TM01 and TM02.
    CICSPA IN(SMFIN004),
           SELECT(PERFORMANCE(INCLUDE(TRAN(XXXX),
                                      TERM(TM01)))),
           SELECT(PERFORMANCE(INCLUDE(TRAN(XXXX),
                                      TERM(TM02)))),
           SUMMARY
  3. INCLUDE and EXCLUDE parameters can be specified in any order within one SELECT statement. However, with multiple SELECT statements, the order is important.
    • The following two commands generate the same Performance Summary report.
      CICSPA IN(SMFIN005),
             SELECT(PERFORMANCE(INCLUDE(TERM(TM01)),
                                EXCLUDE(TRAN(XXXX)))),
             SUMMARY
      CICSPA IN(SMFIN005),
             SELECT(PERFORMANCE(EXCLUDE(TRAN(XXXX)),
                                INCLUDE(TERM(TM01)))),
             SUMMARY
    • The following command also generates the same Performance Summary report
      CICSPA IN(SMFIN005),
             SELECT(PERFORMANCE(EXCLUDE(TRAN(XXXX)))),
             SELECT(PERFORMANCE(INCLUDE(TERM(TM01)))),
             SUMMARY
    • However, the following command generates a different Performance Summary report. This one includes all transactions for terminal TM01, including transaction XXXX.
      CICSPA IN(SMFIN005),
             SELECT(PERFORMANCE(INCLUDE(TERM(TM01)))),
             SELECT(PERFORMANCE(EXCLUDE(TRAN(XXXX)))),
             SUMMARY
  4. Remember that global SELECT operands cannot be removed. The following commands generate three Performance List reports:
    1. The first report contains data for transaction XXXX on terminal TM01
    2. The second report contains the same data as the first report as well as data for transaction YYYY on terminal TM02
    3. The third report contains the same data as the second report as well as data for transaction ZZZZ on terminal TM03
    CICSPA IN(SMFIN006),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM01),
                                      TRAN(XXXX)))),
           LIST,
           SELECT(PERFORMANCE(INCLUDE(TERM(TM02),
                                      TRAN(YYYY)))),
           LIST
    CICSPA IN(SMFIN006),
           SELECT(PERFORMANCE(INCLUDE(TERM(TM03),
                                      TRAN(ZZZZ)))),
           LIST
    If three exclusive reports are wanted, specify the SELECT statements as operands. The following command generates three Performance List reports:
    1. The first report contains data for transaction XXXX on terminal TM01
    2. The second report contains data for transaction YYYY on terminal TM02
    3. The third report contains data for transaction ZZZZ on terminal TM03
    CICSPA IN(SMFIN006),
           LIST(SELECT(PERFORMANCE(INCLUDE(TERM(TM01),
                                           TRAN(XXXX))))),
           LIST(SELECT(PERFORMANCE(INCLUDE(TERM(TM02),
                                           TRAN(YYYY))))),
           LIST(SELECT(PERFORMANCE(INCLUDE(TERM(TM03),
                                           TRAN(ZZZZ)))))

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//selinex.htm