TAA Tools

The  Convert Member  List command  converts  a list  of  members to  an
outfile  using an API  to access  the members.   The outfile  format is
the  same as  DSPFD *MBRLIST (QAFDMBRL  with a format  of QWHFDML), but
the CVTMBRLST  command  allows a  member name  parameter  and a  source
type parameter.   Generic member names  may be specified.   This allows
for faster creation of member lists.

The API used is QUSLMBR.

A typical command would be:

             CVTMBRLST     FILE(xxx) MBR(yyy*) OUTLIB(QTEMP)

One record  for each member in the file  would be output to the MBRLSTP
file in QTEMP.   The format  of the file  is the  same as the  QAFDMBRL
outfile   with  the   QWHFDML  format   (see  the   later  section   on

Performance considerations

The  QUSLMBR  API operates  quickly on  a  single member  or  a generic
member name when  a small number  of members are  accessed.   Accessing
all members in a  large source file is approximately the  same speed of

The selection  by source type is done via  the CVTMBRLST processing and
not  by the API.   Consequently, all members must  be accessed and then
a determination is made if  the source type matches the request  on the
command.   This type  of processing is  usually faster than  creating a
DSPFD  *MBRLIST outfile and  then doing selection in  your own program.


The format name QWHFDML and fields  are the same as that used by  DSPFD
*MBRLIST.    The  following  exceptions  for  data  within  the  fields

  **   MLFTYP.  For 'File type' - Only a P or L will be returned.

  **   MLSTGR.  For 'Storage freed' - Will always be blank.

CVTMBRLST escape messages you can monitor for

      TAA9891    No members exist (sent if NOMBRESC(*YES) is specified

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

Command parameters                                    *CMD

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

   MBR           The members  to be  converted.   The default is  *ALL.
                 A single  member or a generic member  name may also be

   SEUTYPE       The  SEU type to  be converted.   The default is *ALL.
                 There is  no  checking against  the value  entered  to
                 determine if it  is a valid SEU type.   All characters
                 are considered valid.

   FRMCHGDATE    The  From change  date to select  on.   The default is
                 *AVAIL  to  mean  all   change  dates  prior  to   the

                 A  'From  change date'  may  be  entered in  job  date
                 format.   The  change date refers  to the  last source
                 change date.

                 The  value  *CURRENT  may  be  entered  to  mean   the
                 current date.

                 This change date is  the same value as appears  in the
                 DSPFD *MBRLIST  QAFDMBRL format for  the fields MLCHGC
                 and  MLCHGD.  This  date is normally  set by SEU after
                 a member  has been edited.   The date  may not be  the
                 same  as  the  MBCHGC/MBCHGD  fields  of  the  QAFDMBR
                 format produced by DSPFD *MBR.

   TOCHGDATE     The  To  change date  to select  on.   The  default is
                 *CURRENT to mean  all change dates  up to the  current

                 A  'To  change  date'  may  be  entered  in  job  date
                 format.   See the  FRMCHGDATE for a  discussion of the
                 SEU change date.

   OUTLIB        The  library  in  which  the  file  MBRLSTP  will   be
                 placed.  The  default is *LIBL.   If the  MBRLSTP file
                 does not already exist, a library must be named.

   OUTMBR        The  member of the  MBRLSTP file to  be used.   If the
                 member  does not exist,  it is added.   The default is

   REPLACE       A *YES/*NO  value  for whether  the member  should  be
                 cleared before  writing records into it.   The default
                 is *YES.

                 *NO  may be  specified to  add records to  an existing

   NOMBRESC      A  *YES/*NO  value  for  whether  to  send  an  escape
                 message  if  no  members  exist  in  the  file  or  no
                 members  are  found  based  on  the  MBR  and  SEUTYPE
                 parameter.   *NO  is the  default  in which  case  the
                 command will  complete  normally and  one record  will
                 be  output with only  file information.   This  is the
                 same approach used by DSPFD *MBRLIST.

                 *YES  may be specified  to cause an  escape message if
                 no records are output.


See the section on Exceptions.


The following TAA Tools must be on your system:

     ABORT           Abort
     CRTDUPPF        Create duplicate PF
     EDTVAR          Edit variable
     EXTLST2         Extract list 2
     HLRMVMSG        HLL Remove message
     RTVDBFA         Retrieve data base attributes
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCMSG       Send escape message
     SNDJLGMSG       Send job log message
     SNDSTSMSG       Send status message


None, the tool is ready to use.

Objects used by the tool

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

   CVTMBRLST     *CMD                   TAADBJP       QATTCMD
   TAADBJPC      *PGM       CLP         TAADBJPC      QATTCL
   TAADBJPR      *PGM       RPG         TAADBJPR      QATTRPG
   TAADBJPP      *FILE      PF          TAADBJPP      QATTDDS

Added to TAA Productivity tools April 23, 2001

Home Page Up to Top