TAA Tools
RTVMBRSUM       RETRIEVE MEMBER SUMMARY                TAADBKV

The Retrieve Member  Summary command returns variables for  such things
as the  number of members, the  number of active records,  and the data
space  size of  all members for  a data base  file.   Both physical and
logical files are  supported.  RTVMBRSUM  is designed for  multi-member
files.   For single  member files,  the RTVMBRD  and RTVLFMD  should be
used.

Because  RTVMBRSUM  returns variables,  it  may only  be used  in  a CL
program.

A typical series of commands would be:

             DCL           &NBRACTRCDS *DEC LEN(15 0)
              .
             RTVMBRSUM     FILE(xxx) NBRACTRCDS(&NBRACTRCDS)

RTVMBRSUM escape messages you can monitor for
---------------------------------------------

None.  Escape messages from based on functions will be re-sent.

Command parameters                                    *CMD
------------------

   FILE          The  qualified name  of  the  data  base  file  to  be
                 retrieved  from.    The   library  value  defaults  to
                 *LIBL.   A  specific library  or  *CURLIB may  also be
                 used.

   RTNLIB        The library  where  the  file exists.    This  may  be
                 helpful if  the qualified  FILE name  is *LIBL.   This
                 is an  optional return variable  that if used  must be
                 specified as *CHAR LEN(10).

   RTNTYPE       The  type of  data base file  that was  found.  Either
                 PF or  LF is  returned.   This is  an optional  return
                 variable  that  if used  must  be  specified as  *CHAR
                 LEN(2).

   NBRMBR        The  number  of  members  in the  file.    This  is an
                 optional  return  variable  that   if  used  must   be
                 specified as *DEC LEN(5 0).

   NBRACTRCDS    The number  of active records  in all of  the members.
                 This  is  an optional  return  variable  that if  used
                 must be specified as *DEC LEN(15 0).

   NBRDLTRCDS    The number of deleted records  in all of the  members.
                 This  is an  optional  return  variable that  if  used
                 must be specified as *DEC LEN(15 0).

   DTASPCSIZ     The  size of the  data space  required for all  of the
                 members.   This  is an  optional return  variable that
                 if used must be specified as *DEC LEN(15 0).

   ACCPTHSIZ     The size  of the access  path space  required for  all
                 of  the  members.   If  an  arrival  sequence file  is
                 specified,  the size will  be 0.  This  is an optional
                 return variable  that  if used  must be  specified  as
                 *DEC LEN(15 0).

Restrictions
------------

Because  RTVMBRSUM returns  variables,  it may  only be  used  in a  CL
program.

Prerequisites
-------------

The following TAA Tools must be on your system:

     SNDESCINF       Send escape information
     SNDESCMSG       Send escape message

Implementation
--------------

None, the tool is ready to use.

Objects used by the tool
------------------------

   Object        Type    Attribute      Src member    Src file
   ------        ----    ---------      ----------    ----------

   RTVMBRSUM     *CMD                   TAADBKV       QATTCMD
   TAADBKVC      *PGM       CLP         TAADBKVC      QATTCL
					

Added to TAA Productivity tools August 15, 2005


Home Page Up to Top