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

Last modified on November 19, 2014 © 1995, 2014 - TAA Tools, Inc.