TAA Tools
RMVOLDMBR       REMOVE OLD MEMBER                      TAADBIO

The Remove  Old  Members command  removes members  that  have passed  a
retention  date.  The  date to check  can be any  or all of  the create
date,  last change date, or last use date.   The command may be used to
clean up files where members  are created for different periods.   Only
multi-member data  files are  valid.  Both  physical and  logical files
are supported.

You must have *OBJEXIST authority to the file to use RMVOLDMBR.

A typical command would be:

             RMVOLDMBR    FILE(xxx) RETAINDAYS(180) CHKDAT(*CRTDAT)

This  would remove all members  based on the create  date of the member
being more than 180 days in the past.

A spooled file is output with a listing of the removed members.

Only data files may be specified (not source files).

A file  specified as  MAXMBRS(1) is  not eligible.   Only  multi-member
files are  eligible.   A file  specified for  multi-members, but  which
contains only a single member is eligible.

You may check for one or more of the following dates:

             Create date
             Last change date
             Last use date

If  multiple criteria  are used,  then all  specified criteria  must be
met to remove the member.

If the member has never been used,  the last use date is considered  to
meet the criteria.

If a member  is locked, an error will  be noted on the listing  and the
command will continue with any additional members in the same file.

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

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

                 Only data files  may be specified (not  source files).
                 A file specified as MAXMBRS(1) is not valid.

   RETAINDAYS    The  number  of  days   in  the  past  to  retain  the
                 members.  A value of 1 to 9999 must be entered.

   CHKDAT        A  list of options  for which date  to check.   One or
                 more  of  the  following  may  be  specified:  *CRTDAT
                 (create  date of  the  member),  *CHGDAT (last  change
                 date  of the  member), *USEDAT (last  use date  of the
                 member).

                 When a member  is first  created, the  change date  is
                 set to the create date.

                 If a member has  never been used, it is  considered to
                 meet the *USEDAT criteria.

                 If  multiple  date  options  are specified,  all  must
                 meet  the criteria or the  member will not be removed.

   RTNFILEMBR    A *YES/*NO  parameter for  whether a  member with  the
                 same  name  as the  file  should  always be  retained.
                 *NO  is the  default  to consider  this member  as any
                 other member (it may be removed).

                 *YES may  be  specified to  always retain  the  member
                 with the same name as the file.

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

See previous comments.

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

The following TAA Tools must be on your system:

     ADDDAT          Add date
     EDTVAR          Edit variable
     EXTLST          Extract list
     EXTLST2         Extract list 2
     RTVDBFA         Retrieve data base file attributes
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     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
   ------        ----    ---------      ----------    ----------

   RMVOLDMBR     *CMD                   TAADBIO       QATTCMD
   TAADBIOC      *PGM       CLP         TAADBIOC      QATTCL
   TAADBIOR      *PGM       RPG         TAADBIOR      QATTRPG
					

Added to TAA Productivity tools July 1, 1998


Home Page Up to Top