TAA Tools
SCNFLDTYP       SCAN FIELD TYPE                        TAADBJZ

The Scan  Field  Type command  scans data  base  files in  one or  more
libraries  for  one  or  more  field  types.    For  example,  you  can
determine  which files  have field types  for date  (L), timestamp (Z),
variable length (W), or BLOB (1).

A typical command would be:

             SCNFLDTYP     FLDTYP(*BIN *VARLEN) LIB(xxx)

By default,  only PF/PF38 file  types are  scanned for.   One line  for
each  data base  physical  file would  be  printed with  the number  of
fields  in  each.   The  format of  each  file would  be  extracted and
scanned for  binary or variable  length field  types.   For each  field
type found, a line would be printed.

Only data files are processed (not source files).

If a file has more than 998 fields, it is flagged and not scanned.

SCNFLDTYP escape messages you can monitor for

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

Command parameters                                    *CMD

   FLDTYP        A list  of up  to 10  field types  to be scanned  for.
                 See  the command prompt  for the valid  values such as
                 *BIN, *PACKED, *VARLEN, etc.

   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

                 *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.


If a file has more than 998 fields, it is flagged and not scanned.


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
     RTVDBFA         Retrieve data base file attributes
     RTVFLDARR       Retrieve field array
     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
   ------        ----    ---------      ----------    ----------

   SCNFLDTYP     *CMD                   TAADBJZ       QATTCMD
   TAADBJZC      *PGM       CLP         TAADBJZC      QATTCL
   TAADBJZC2     *PGM       CLP         TAADBJZC2     QATTCL
   TAADBJZR      *PGM       RPG         TAADBJZR      QATTRPG

Added to TAA Productivity tools September 15, 2002

Home Page Up to Top