TAA Tools
SCNMBRA         SCAN MEMBER ATTRIBUTES                 TAADBOF

The  Scan  Member  Attributes command  scans  one  or  more  data  base
members in  a library for attribute values.   For example, you can scan
for  the number of members  with more than 1000  records or all members
that have  a  keyed access  path.    This acts  as  a simple  query  to
determine the value of attributes of members.

A typical command would be:

              SCNMBRA   ATTR(NBRRCD) FILE(xxx/*ALL)
                         SCNVAL(100) SCNOPR(*GT)

A spooled file  would be displayed of all members  in the named library
that have more than 100 records.

SCNMBRA escape messages you can monitor for
-------------------------------------------

      TAA9891    No members were found

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

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

   ATTR          The  Member attribute  to be  scanned for.   The value
                 must be one of the following:

                 ACCPTH.   The access  path used  for the  member.   It
                 must be a scan value of *ARRIVAL or *KEYED.

                 ACCPTHVLD.   Whether the  access path  for the  member
                 is  valid to be  used.  The  scan value must  be *YES,
                 *NO, or *HELD.

                 ALLOCATE.    Whether  storage  is  allocated  for  the
                 member.  The scan value must be *YES or *NO.

                 ALTCOLSEQ.   Whether an  alternate collating  sequence
                 is used.  The scan value must be *YES or *NO.

                 ALWDLT.    Whether records  can  be  deleted from  the
                 member.  The scan value must be *YES or *NO.

                 ALWRD.   Whether records can  be read from the member.
                 The scan value must be *YES or *NO.

                 ALWUPD.    Whether  records  can  be  updated  in  the
                 member.  The scan value must be *YES or *NO.

                 ALWWRT.   Whether  new  records can  be  added to  the
                 member.  The scan value must be *YES or *NO.

                 CHGDAT.   The last change date of  the member.  A date
                 in Job format must be used for the scan value.

                 CONTIG.  Whether  the storage for  the member must  be
                 contiguous.  The scan value must be *YES or *NO.

                 CRTDAT.   The create date  of the member.   A  date in
                 Job format must be used for the scan value.

                 CURINC.    The current  number  of  storage increments
                 used.   A numeric  value  must be  entered as  a  scan
                 value.

                 EXPDAT.  The  expiration date of  the member.   A date
                 in Job format must be used for the scan value.

                 EXTDSC.   Whether the member  is externally described.
                 The scan value must be *YES or *NO.

                 FRCACCPTH.     Whether  the   access  path  should  be
                 forced.   The  scan value  must  be *YES  or *NO.    A
                 blank  value  may  be  entered  for  arrival  sequence
                 access paths.

                 FRCRATIO.     Whether  to   force  record  changes  to
                 auxiliary storage.   If  the scan  value  is *NONE,  a
                 scan operator  of *EQ or *NE  may be used.   A numeric
                 value may also be entered as a scan value.

                 INXENT.   The number of index  entries for the member.
                 A numeric scan value must be used.

                 INXSIZ.  The size  of the index in  bytes.  A  numeric
                 scan value must be used.

                 JOIN.  Whether  the member is  of a joined file.   The
                 scan value must be *YES or *NO.

                 LVLCHK.   Whether to check the level  ID of the member
                 that  was used  when a  program opens  the file.   The
                 scan value must be *YES or *NO.

                 MAINT.   The type  of maintenance to  be performed  on
                 the  access path.   The  scan value  of  *IMMED, *DLY,
                 *REBLD,  or blank may be used.   Blanks should be used
                 for arrival sequence members.

                 MAXINC.   The  maximum number  of  storage  increments
                 that may be  used to increase the size  of the member.
                 A numeric scan value must be used.

                 MAXKEYLEN.    The maximum  key length  used  for keyed
                 members.  A numeric scan value must be used.

                 MAXMBR.   The  maximum  number  of  members  that  may
                 exist in  the  file.   A numeric  scan  value must  be
                 used unless the value *NOMAX is entered.

                 MAXRCDLEN.   The maximum record length  of the member.
                 A numeric scan value must be used.

                 NBRDLTRCD.   The number of  deleted records that exist
                 in the member.  A numeric scan value must be used.

                 NBRFMT.   The  number of  formats in  the  member.   A
                 numeric scan value must be used.

                 NBRMBR.   The  number  of members  that  exist in  the
                 file.  A numeric scan value must be used.

                 NBRRCD.    The number  of  records that  exist  in the
                 member.  A numeric scan value must be used.

                 RCDCAP.   The  maximum  number  of  records  that  may
                 exist in  the member.  If  *NOMAX is entered  the scan
                 operator  must be  *EQ or  *NE.   A numeric  value may
                 also be entered as a scan value.

                 RSTDAT.  The restore  date of the member.   A date  in
                 Job format must be used for the scan value.

                 SAVDAT.  The save  date of the member.  A  date in Job
                 format must be used for the scan value.

                 SELOMT.   Whether  select/omit of  key values  is used
                 for  the member.  The scan  value must be *YES or *NO.

                 SRCCHGDAT.    The  last  source  change  date  of  the
                 member.   A date  in Job format  must be used  for the
                 scan  value.  The value is  only meaningful for source
                 members.

                 SRCTYPE.  The source type  such as CLP, PF, RPG,  etc.
                 The  source types  described  as  valid for  WRKMBRPDM
                 MBRTYPE  parameter may  be used.    The value  is only
                 meaningful for source members.

                 TEXT.  The  member text.   The scan  operator must  be
                 *CT.   The  scan  value  should  be entered  in  upper
                 case.    The  member  text  is  folded to  upper  case
                 before  scanning.    Trailing blanks  are  trimmed off
                 the scan value.

                 USEDAT.  The  last used  date of the  member.  A  date
                 in Job format must be used for the scan value.

                 WAITFILE.  Then  number of seconds to wait  for a lock
                 to  be  satisfied when  opening  the member.    If the
                 scan value is *IMMED or  *CLS, the scan operator  must
                 be *EQ or *NE.  A numeric value may be entered.

                 WAITRCD.     The  number   of  seconds  to   wait  for
                 accessing a  record that is locked in  the member.  If
                 the  scan  value  is   *IMMED  or  *NOMAX,  the   scan
                 operator must be *EQ  or *NE.  A numeric  value may be
                 entered.

   FILE          The  qualified name  of  the file  to be  scanned.   A
                 single  file, a generic name,  or *ALL may be entered.

                 The library  qualifier must be  entered as a  specific
                 library name.

   SCNVAL        The value  to be scanned for.   Up to 10  bytes may be
                 entered.

                 To scan for blank entries, leave the value blank.

                 If   SCNOPR(*CT)   is  entered   when   ATTR(TEXT)  is
                 specified,  the  SCNVAL  should  be  entered   without
                 quotes as the  member text description will  be folded
                 to upper case before scanning.

   SCNOPR        The scan operator to be used.  *EQ is the default.

                 *NE,  *GT, *GE,  *LT, *LE,  or  *CT (contains)  may be
                 entered.   Non-meaningful functions  such as  scanning
                 the ALLOCATE  attribute  (supports only  *YES or  *NO)
                 for a  scan operator other than  *EQ/*NE are rejected.

   MBR           The member name to be scanned.

                 *ALL  is  the default  for  all members  of  the named
                 file.

                 A specific or generic member may also be entered.

   DATATYPE      The type of members to be scanned.

                 *ALL is the default for all types.

                 *DATA may be entered  to scan just data type  members.

                 *SRC may be entered to scan just source members.

   FILETYPE      The type of file be scanned.

                 *ALL is the default for all types.

                 *PF may be entered to scan just physical files.

                 *LF may be entered to scan just logical files.

   OUTPUT        How  to output  the  results.   *  is  the default  to
                 display  the spooled  file if  the command  is entered
                 interactively.  The spooled  file is deleted after  it
                 is displayed if  it is ended with F3/F12  or the Enter
                 key.   To  retain the  spooled file,  you may  use the
                 the System Request 'Cancel'  function and the  spooled
                 file will exist in a HLD status.

                 If  the command  is  entered  in  batch or  *PRINT  is
                 specified,  the spooled file  is output  and retained.


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

None.

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

The following TAA Tools must be on your system:

     CHKGENERC       Check generic
     CHKOBJ3         Check object 3
     CHKSRCTYP3      Check source type 3
     CVTDAT          Convert date
     CVTMBRD         Convert member description
     RSNLSTMSG       Resend last message
     RTVVALA         Retrieve value attributes
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     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
   ------        ----    ---------      ----------    ----------

   SCNMBRA       *CMD                   TAADBOF       QATTCMD
   TAADBOFC      *PGM       CLP         TAADBOFC      QATTCL
   TAADBOFR      *PGM       RPG         TAADBOFR      QATTRPG
					

Added to TAA Productivity tools October 15, 2013


Home Page Up to Top