TAA Tools
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


Home Page Up to Top