TAA Tools
SCNDBF          SCAN DATA BASE FILE                    TAADBOL

The Scan Data Base File command scans one or more members of data
base files for up to 20 strings.  A listing is output with one line
for each time one of the strings is found in a record.  The relative
record number of the record and the position where the string was
found is described.

You must have *ALLOBJ special authority to use SCNDBF.

A typical command would be:

            SCNDBF      ARGUMENT(AAA) LIB(XYZ)

All data base members (both source and data) would be found in
library XYZ.  Every record in each member would be scanned for AAA.
If found a line would be listed.  The spooled file is displayed upon
completion.

If only source members are to be scanned, the SCNSRC command is a
more specific solution.

Any errors are noted.

SCNDBF escape messages you can monitor for
------------------------------------------

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

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

   ARGUMENT      Up to 20 arguments may be scanned for.  If the
                 argument contains lower case, the argument must be
                 surrounded with quotes.

   LIB           The library to be processed.  A list of up to 40
                 libraries or generic libraries may be entered.  The
                 special values *LIBL, *USRLIBL, *CURLIB, *ALL, or
                 *ALLUSR

   FILE          The file to be processed within the library.  *ALL
                 is the default.  A generic name may be specified.

   DATATYPE      The type of data to be processed.  *ALL is the
                 default.  Either *DATA (data files) or *SRC (source
                 files) may be entered.

                 If only source members are to be scanned, the SCNSRC
                 command is a more specific solution.

   LIBTYPE       The library type to be processed.  *ALL is the
                 default.  Either *PROD (for PROD type libraries) or
                 *TEST (for TEST type libraries) may be entered.

   OMITLIB       A list of up to 40 libraries or generic library
                 names that should be omitted.  *NONE is the default.

                 An omit list may not be entered for LIB(*CURLIB) or
                 if only non-generic libraries are specified.

                 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 OMITLIBS(ABC) and library ABC is not on
                 the library list, no error occurs.

   OUTPUT        How to output the results.  * is the default to
                 display the spooled file if the command is entered
                 interactively.  If the display is ended with F3/F12
                 or the Enter key, the spooled file is deleted after
                 it is displayed.  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
------------

You must have *ALLOBJ special authority to use SCNDBF.

Records with null values cannot be processed and will list as an
error with CPF5029.  If any exist, the remaining records in the file
are bypassed.

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

The following TAA Tools must be on your system:

     CHKALLOBJ       Check *ALLOBJ special authority
     EXTLST2         Extract list 2
     HLRMVMSG        HLL remove message
     RMVMSGKEY       Remove message key
     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
   ------        ----    ---------      ----------    ----------

   SCNDBF        *CMD                   TAADBOL       QATTCMD
   TAADBOLC      *PGM       CLP         TAADBOLC      QATTCL
   TAADBOLR      *PGM       RPG         TAADBOLR      QATTRPG
					

Added to TAA Productivity tools October 15, 2014


Home Page Up to Top