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