TAA Tools
CHKBLKFLD       CHECK BLANK FIELDS                     TAADBLW

The Check Blank  Fields command checks all  values for each field  in a
file to  determine if only  blanks exist for character  fields or zeros
for  decimal fields.  This  is intended as a  debugging aid to check if
a program  that 'adds new  records' is  populating the correct  fields.
If only some  records in the file contain values,  the field is flagged
with a different code.

A typical command would be:

             CHKBLKFLD   FILE(xxx)

A listing  would be displayed with one line  for each field name in the
file.   A %2  flag would  identify any  character  fields that  contain
only  blanks  or  decimal  fields that  contain  only  zeros  in  every
record.   A count is  kept of the  records which contain  values and if
the count does  not equal  the number  of records  read, a  %3 flag  is
used.

If the  DFT keyword is  used in DDS  to cause a  field to  be populated
with other than  blanks or zeros, the field  will be considered to have
data.

CHKBLKFLD escape messages you can monitor for
---------------------------------------------

      TAA9893    The member has no records.

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

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

   FILE          The  qualified  name  of  the  data  base  file  to be
                 checked.   The library  value  defaults to  *LIBL.   A
                 specific library or *CURLIB may also be used.

   MBR           The member to  be checked.  *FIRST is  the default.  A
                 specific member or *LAST may be specified.

   OMITFLD       A  list of up  to 50 fields  that may  be omitted from
                 the analysis.    The  default  is  *NONE  meaning  all
                 fields are checked.

   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  the command  is  entered  in  batch or  *PRINT  is
                 specified,  the spooled file  is output  and retained.


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

The record length may not exceed 9999 bytes.

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

The following TAA Tools must be on your system:

     CHKDUPLST       Check duplicates in a list
     EDTVAR          Edit variable
     EXTLST          Extract list
     EXTLST2         Extract list 2
     RSNLSTMSG       Resend last message
     RTVDBFA         Retrieve data base file attributes
     RTVFLDA         Retrieve field attributes
     RTVFLDARR       Retrieve field array
     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
   ------        ----    ---------      ----------    ----------

   CHKBLKFLD     *CMD                   TAADBLW       QATTCMD
   TAADBLWC      *PGM       CLP         TAADBLWC      QATTCL
   TAADBLWR      *PGM       RPG         TAADBLWR      QATTRPG
					

Added to TAA Productivity tools May 15, 2008


Home Page Up to Top