To display options for CA Datacom/DB tables accessible through URTs from a specified CICS system, or all CICS systems, issue the DBEC or DBEX transaction followed by the INQUIRE command.
If you issue the INQ command with the DBEX transaction ID, you are not able to update any fields on the scrollable display. If you issue the command with DBEC, you can make entries in certain fields to override table options specified in the URT definition. (Any alterations made take effect immediately and are valid only during the life of the CICS session.)
The following is an example of a URT definition. A URT begins with a DBURSTR macro, contains one or more DBURTBL macros, each defining a particular CA Datacom/DB table, and ends with a DBUREND macro. The values for the bold-faced parameters in this example are displayed on the Table-level inquiry.
URT TITLE 'ONLINE URT FOR REQUESTS USING MULTI-USER FACILITY'
DBURSTR MULTUSE=YES,WRITE=NO,
CBSIO=0,PRTY=7,TXNUNDO=YES,TIMEMIN=5,TIMESEC=0
DBURTBL TBLNAME=PAY,DBID=004,
AUTODXC=YES,BYPOPEN=NO,SYNONYM=YES,UPDATE=YES
DBUREND DBSQL=YES,USRINFO=CAICICS
END
Invoke the inquiry transaction sample as shown following to display information at the Table-level to change the previously highlighted values.
►►─┬─ DBEC ─┬─ INQuire,TBL(nnnn) ─┬────────────┬─┬──────────────────────┬─────►◄ └─ DBEX ─┘ └─ ,limiter ─┘ └─ ,SIDname(xxxxxxxx) ─┘
(Required) Specify a transaction ID valid with Enhanced commands used to monitor URTs. Select the transaction ID for which you are authorized. Leave a space between the transaction ID and the command.
(Required) Specifies that CA Datacom CICS Services is to perform an Inquiry. (INQ and I are valid abbreviations.)
(Required) TBL specifies the inquiry is to invoke the Table-level display. The value within the parentheses identifies the suffix of the URT.
Specifies that you want to display only the URT with the specific 4-digit suffix nnnn.
Alternately, instead of using the nnnn suffix to specify only a specific URT, you can use the wildcard symbol ? (a question mark) to accept any digit 0 through 9 for any (or all) of the four digits of the suffix.
(Optional) Limits the inquiry to URTs of designated type, status, how they are defined for opening, or those with no CICS System Definition data set (CSD) entry. The following are the values for designating limiters of each type:
URTs dynamically built by a CA product.
URTs for applications issuing SQL statements.
URTs explicitly closed through a DBOC CLOSE= command, a DBEC PERform,URT(nnnn),CLOSE, or an entry of C in the Action column of a DBEC INQ,URT(nnnn) display.
URTs with a close in progress, where close is invoked at the completion of the current read or update.
URTs which are currently open.
Open requested by DBEC or DBOC OPEN= command, or a request requires an AUTO open but request has not completed in CA Datacom/DB.
URTs defined as AUTO or DEFER which have not been opened by a program call or a DBOC/DBEC transaction. (UNO is a valid abbreviation.)
URTs defined to be opened when required by a program.
URTs defined to be opened only by an explicit DBOC/DBEC command. (DEF is a valid abbreviation.)
URTs opened at CA Datacom CICS Services startup, that is to say those not defined for AUTO or DEFER.
URTs have no CICS System Definition data set (CSD) entry. Such URTs are available for dynamic creation by a CA product.
(Optional) Limits the inquiry to a specific MUF by the SID name associated with that MUF (see the DBURSTR macro SIDNAME= parameter in the CA Datacom/DB Database and System Administration Guide and the DBCSID macro SIDNAME= parameter in the System Reference Guide) or limits the inquiry to a range of MUFs by specifying any number of leading characters of the SID name, followed by an asterisk (*). Omitting the SIDname(xxxxxxxx) limiter results in URTs in all MUFs being displayed. (SID is a valid abbreviation.)
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|