When inquiries are made at the table level, the display includes the number and status of each URT, similar to the URT status inquiry display. In addition, the table names and database IDs are displayed for each URT.
SYSID = CVDS CA Datacom CICS Services APPLID = A31ICXDS DBEC I,TBL(10) SYS URT TYP STATUS TABLE DBID UPD BYP SYN AUT DBIDM SIDNAME MUF *LOC 0010 STD UNOPENED ACT 00010 YES NO YES YES DBSIDPR 01 CUS 00010 YES NO YES YES DTL 00010 YES NO YES YES ORD 00010 YES NO YES YES ITM 00010 YES NO YES YES NUM 00010 YES NO YES YES RCP 00010 YES NO YES YES SAL 00010 YES NO YES YES SHP 00010 YES NO YES YES PF3: RETURN PF7: BACKWARD PF8: FORWARD
When you specify TBL rather than URT in the command format, CA Datacom CICS Services presents a scrollable display containing 13 columns of data. The first four columns and the last two columns repeat the SYS, URT, TYP, STATUS, SIDNAME, and MUF data which is displayed on the corresponding URT-Level inquiry. Data appears in these fields only once per URT. The remaining seven columns display information on the tables making up the URT definition. Any field marked with a Y in the Chg column is updatable when the STATUS displayed is UNOPENED or CLOSED.
|
Column |
Chg |
Description |
|---|---|---|
|
SYS |
|
Identifies the CICS system to which this display line refers. *LOC means local CICS or TOR. |
|
URT |
|
Identifies the sequence number of the URT. |
|
TYP |
|
Indicates the type of URT. STD URT for applications issuing CA Datacom/DB commands. SQL URT for applications issuing SQL statements. DYN URT dynamically built by another CA product. |
|
STATUS |
|
Indicates the OPEN status of the URT with the following values: UNOPENED Not yet opened by a program call or a DBEC or DBOC transaction. CLOSED Explicitly closed with a DBEC or DBOC CLOSE=. CLOSING Close requested by DBEC or DBOC CLOSE= command, but not yet closed pending completion of a read in progress or a transaction having exclusive control. OPEN Opened by CA Datacom CICS Services but no transaction to close it has been issued. OPENING Open requested by DBEC or DBOC OPEN= command, or a request requires an AUTO open but request has not completed in CA Datacom/DB. |
|
TABLE |
|
Name of the CA Datacom/DB table with the URT. |
|
DBID |
|
Number of the DATABASE which contains the table. |
|
UPD |
Y |
YES Indicates that this URT permits applications to update the named table. NO Indicates that update of the named table is not permitted using this URT. |
|
BYP |
Y |
YES When the URT is opened, the designated table is bypassed from the opening. Any attempt to access this table, using this URT, results in a CA Datacom/DB return code of 05. NO When the URT is opened, the designated table is opened during the opening. |
|
SYN |
Y |
YES Indicates that SYNONYM=YES is specified in the DBURTBL macro for this URT. NO Indicates that SYNONYM=NO is specified in the DBURTBL macro for this URT. |
|
AUT |
Y |
NO Indicates that CA Datacom/DB does not automatically drop exclusive control for this table when a second command is issued from the same Request Area. YES Indicates that CA Datacom/DB automatically drops exclusive control for this table when a second command is issued from the same Request Area. |
|
DBIDM |
|
This global URT is using DBID remapping for this table. This is the DBID that is passed to the MUF in the request. |
|
SIDNAME |
|
The value specified in the relative DBCSID macro of the DBCVTPR generation for the name of the DBSIDPR macro generated module to be loaded and used for this Multi-User Facility. |
|
MUF |
|
The number of the MUF with which this URT is associated, relative to the number of the DBCSID macro appended to the DBCVTPR. |
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|