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