TAA Tools
SCNDBFLEN       SCAN DATA BASE RECORD LENGTH           TAADBKB

The  Scan Data  Base  File  Record Length  command  scans one  or  more
libraries for  data base files  that exceed a  specified record length.
The  record length of a  file is specified on  the CRTPF command RCDLEN
parameter for  program  described files  or  is the  sum of  the  field
lengths for  an externally described file.   An omit  list of libraries
may also be specified.

You  must have *ALLOBJ special authority to  specify *ALL or *ALLUSR as
the libraries to be scanned.

Only data  files  are scanned  for  either  physical, logical  or  both
types of files.  Source files are excluded.

A typical command would be:

             SCNDBFLEN    RCDLEN(nnn) LIB(xxx)

All data  base files  in the  named library  would be  found and  those
with  a record  length greater  than or equal  to the  specified length
would be listed.

SCNDBFLEN escape messages you can monitor for
---------------------------------------------

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

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

   RCDLEN        The record length to scan  for.  The record length  of
                 a  file  is  specified on  the  CRTPF  command  RCDLEN
                 parameter  for program described  files or is  the sum
                 of  the  field  lengths  for  an  externally described
                 file.   The value must  be between 1  and 32767.   All
                 files with  a record length  equal to or  greater than
                 that specified will be listed.

   LIB           The  library or  libraries to be  scanned.   A list of
                 to 300 libraries may be  entered.  A generic name  may
                 be  used  or  the   special  values  *LIBL,  *USRLIBL,
                 *CURLIB, *ALL, or *ALLUSR.

                 You  must have  *ALLOBJ  special authority  to specify
                 *ALL or *ALLUSR.

   DBFTYPE       The DBF  file type  to process.   The  default is  *PF
                 for all physical  file types (includes both PF  and TB
                 types).

                 *LF  may  be   entered  for  all  logical  file  types
                 (includes both LF and VW types).

                 *ALL may be entered for both *PF and *LF types.

   OMITLIB       A list of up to 300 libraries to be omitted.

                 An omit list may not be entered for LIB(*CURLIB).

                 Any library entered is checked for existence.

                 No  check occurs to see if  an omit library would have
                 been  selected.     For  example,  if  LIB(*LIBL)   is
                 entered with  OMITLIB(ABC) and  library ABC is  not on
                 the library list, no error occurs.

   OUTPUT        How  the  output  should  be  displayed.    * means  a
                 display   appears    if    the   command    is    used
                 interactively.   If  the command  is run  in batch  or
                 *PRINT is specified, a spooled file is output.

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

You must  have *ALLOBJ special authority to  specify *ALL or *ALLUSR as
the libraries to be scanned.

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

The following TAA Tools must be on your system:

     CHKALLOBJ       Check *ALLOBJ special authority
     CHKDUPLST       Check duplicate list
     CHKGENERC       Check generic
     CHKGENOBJ       Check generic object
     CHKOBJ3         Check object 3
     CMPLSTPARM      Compare list parameters
     CRTDUPPF        Create duplicate physical file
     CVTLIBDBF       Convert library data base files
     EXTLST          Extract list
     EXTLST2         Extract list 2
     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
   ------        ----    ---------      ----------    ----------

   SCNDBFLEN     *CMD                   TAADBKB       QATTCMD
   TAADBKBC      *PGM       CLP         TAADBKBC      QATTCL
   TAADBKBR      *PGM       RPG         TAADBKBR      QATTRPG
					

Added to TAA Productivity tools September 15, 2002


Home Page Up to Top