DSPUNQKEYT DISPLAY UNIQUE KEY TOTALS TAADBNV |
The Display Unique Key Totals command displays or lists members in
one or more data files in a library. The number of unique keys for
the first 4 keys of each keyed access path are listed. This can
provide a better understanding of the data that makes up the keys of
the file.
A typical command would be:
DSPUNQKEYT FILE(ABC/*ALL)
All member information would be accessed for the data base files
(excluding source) for library ABC. A line would be output for each
keyed access path member describing the number of unique keys for the
first 4 keys. If a logical member exists, the number of data records
in the first based on physical member would be shown.
If a file has multiple PFILE keywords, a line appears for each
member.
DSPUNQKEYT escape messages you can monitor for
----------------------------------------------
TAA9894 No files selected
Escape messages from based on functions will be re-sent.
DSPUNQKEYT Command parameters *CMD
-----------------------------
FILE The qualified name of the file to be processed. A
specific or generic name may be used or the special
value *ALL.
A library name must be specified.
OUTPUT How to output the results. * is the default to
display the spooled file if the command is entered
interactively. If the display is ended with F3/F12
or the Enter key, the spooled file is deleted after
it is displayed. To retain the spooled file, you
may use the the System Request 'Cancel' function and
the spooled file will exist in a HLD status.
If the command is entered in batch or *PRINT is
specified, the spooled file is output and retained.
Restrictions
------------
None.
Prerequisites
-------------
The following TAA Tools must be on your system:
CVTMBRD Convert member description
RMVMSGKEY Remove message key
RSNLSTMSG Resend last message
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
SNDESCINF Send escape information
SNDESCMSG Send escape message
SNDSTSMSG Send status message
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
DSPUNQKEY *CMD TAADBNV QATTCMD
TAADBNVC *PGM CLP TAADBNVC QATTCL
TAADBNVC2 *PGM CLP TAADBNVC2 QATTCL
TAADBNVR *PGM RPG TAADBNVR QATTRPG
|
Added to TAA Productivity tools October 15, 2013