To display options for CA Datacom/DB tables accessible through URTs from a CICS system, issue an Enhanced INQuire command.
If you issue the INQ command with the DBEX transaction ID, or its substitute, you are not able to update any fields on the scrollable display. If you issue the command with DBEC, or its substitute, you may make entries in certain fields to override table options specified in the URT definition.
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 following transaction to display how TBLNAM=, DBID= (or alternately DBIDUSER= and DBIDMUF=), AUTODXC=, BYPOPEN=, SYNONYM=, and UPDATE= parameters are defined by DBURTBL macros for all tables within specified URT.
►►─┬─ DBEC ─┬─ INQ,TBL(nnnn) ─┬──────────────────────┬─┬────────────┬─────────►◄ └─ DBEX ─┘ └─ ,SIDname(xxxxxxxx) ─┘ └─ ,limiter ─┘
(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.
(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—9 for any (or all) of the four digits of the suffix.
See Command Examples.
(Optional) Specify one specific SID name to which the URT inquiry applies by 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 any number of leading characters of SID names, followed by an asterisk (*) to specify a range of SID names to which the URT inquiry applies by MUFs. Omitting the SIDNAME(xxxxxxxx) limiter results in the command being applied to all MUFs in the remote systems. (SID is a valid abbreviation.)
(Optional) Limits the inquiry to URTs of designated type, status, how defined for opening, or those with no CICS System Definition data set (CSD) entry. The following are values for designating limiters of each type:
DYN
URTs dynamically built by a CA product.
SQL
URTs for applications issuing SQL statements.
CLOSE
URTs explicitly closed through a DBOC CLOSE= command, a PERform,URT(nnnn),CLOSE, or an entry of C in the Action column of a DBEC INQ,URT(nnnn) display.
CLOSING
URTs with a close in progress, where close is invoked at the completion of the current read or update.
OPEN
URTs that are currently open.
OPENING
Open is in progress by CA Datacom CICS Services.
UNOpened
URTs defined as AUTO or DEFER that have not been opened by a program call or a DBOC/DBEC transaction. (UNO is a valid abbreviation.)
AUTO
URTs defined to be opened when required by a program.
DEFer
URTs defined to be opened only by an explicit DBOC/DBEC command. (DEF is a valid abbreviation.)
PLT
URTs opened at CA Datacom CICS Services startup, that is to say those not defined for AUTO or DEFer.
NOCSD
URTs that have no CICS System Definition data set (CSD) entry. Such URTs are available for dynamic creation by a CA product.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|