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 = A31ICVDS 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 DBDVM5 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 that 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.
Identifies the CICS system to which this display line refers. *LOC means local CICS or TOR.
Identifies the sequence number of the URT.
Indicates the type of URT.
URT for applications issuing CA Datacom/DB commands.
URT for applications issuing SQL statements.
URT dynamically built by another CA product.
Indicates the OPEN status of the URT with the following values:
Not yet opened by a program call or a DBEC or DBOC transaction.
Explicitly closed with a DBEC or DBOC CLOSE=.
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.
Opened by CA Datacom CICS Services but no transaction to close it has been issued.
Open is in progress by CA Datacom CICS Services.
Name of the CA Datacom/DB table with the URT.
Number of the database that contains the table.
Allows the table to be updated.
Indicates that this URT permits applications to update the named table.
Indicates that update of the named table is not permitted using this URT.
Allows the table to be bypassed.
Specifies that when the URT is opened, the designated table is bypassed (and therefore not opened) during the opening. Any attempt to access this table, using this URT, results in a CA Datacom/DB return code of 05.
Specifies that when the URT is opened, the designated table is opened during the opening.
Specifies SYNONYM= in the DBURTBL macro
Indicates that SYNONYM=YES is specified in the DBURTBL macro for this URT.
Indicates that SYNONYM=NO is specified in the DBURTBL macro for this URT.
Specifies whether exclusive control for the table is automatically dropped.
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.
Indicates that CA Datacom/DB automatically drops exclusive control for this table when a second command is issued from the same Request Area.
For a global URT using DBID remapping, this is the number of the database that contains the table to be accessed in the MUF and overrides the DBID specified in the request.
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 MUF.
Number of the MUF that contains the tables for this URT. In a single MUF environment, this number is always one.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|