CVTMBRLST CONVERT MEMBER LIST TAADBJP |
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
Exceptions).
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
DSPFD *MBRLIST.
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.
Exceptions
----------
The format name QWHFDML and fields are the same as that used by DSPFD
*MBRLIST. The following exceptions for data within the fields
exists:
** 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
entered.
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
TOCHGDATE.
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
date.
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
MBRLSTP.
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
member.
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.
Restrictions
------------
See the section on Exceptions.
Prerequisites
-------------
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
Implementation
--------------
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