TAA Tools

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

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

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.


The record length may not exceed 9999 bytes.


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


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