TAA Tools
CMPDBF      COMPARE DATA BASE FILE                     TAADBFQ

The Compare Data Base  File command compares two data  base members and
prints a  listing of the records  that differ.  Options  exist to print
in character or hex and to compare a range of positions.

A typical command would be entered as:

      CMPDBF      FROMFILE(LIBA/FILEX) TOFILE(LIBB/FILEX)

A  specific member  may be  named in  each file.   An option  exists to
print in hex rather than character.

Spooled output  occurs  which describes  the  actual file  and  members
used.    If  any  differences   exist,  the  records  that  differ  are
described  and  the  locations  within  the  records  that  differ  are
highlighted with asterisks.

The files can be any length up  to 9999 bytes, but the formats must  be
the same.

CMPDBF  can be  used  for  source members.    However,  the CMPSRC  and
CMPSRC2  TAA Tools are more  specific tools to  compare source members.

An option exists to compare all members in the file.

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

   FROMFILE      The qualified  file  name  of  the  FROM  file  to  be
                 compared.   The library  qualifier defaults to  *LIBL.

   FROMMBR       The  member name  in  the  FROMFILE to  compare.   The
                 default   is  *FIRST.    *ALL   may  be  specified  if
                 TOMBR(*ALL) is  used  to compare  all  members of  the
                 file.

   TOFILE        The  qualified  file  name   of  the  TO  file  to  be
                 compared.   The  library qualifier defaults  to *LIBL.

   TOMBR         The member  name  in  the  TOFILE  to  compare.    The
                 default  is  *FIRST.     *ALL  may  be   specified  if
                 FROMMBR(*ALL)  is used to  compare all  members of the
                 file.

   FROMCOL       The 'From'  column  to  begin  the  comparison.    The
                 default  is 1.    If  less  than the  full  record  is
                 compared,  the  positions  that  are  not  within  the
                 FROMCOL/TOCOL  range are  set to  blanks before making
                 a comparison.

   TOCOL         The 'To' column  to end the  comparison.  The  default
                 is *END  which means the last position  of the record.
                 If  less   than  the  full  record  is  compared,  the
                 positions  that  are  not  within  the   FROMCOL/TOCOL
                 range are  set to  blanks before making  a comparison.

   OUTFMT        The  output  format  to use.    The  default is  *CHAR
                 meaning the  records  will  be  printed  as  character
                 data.  *HEX may  be specified to print the  records in
                 both character and hex mode.

   DLTSPLF       A  *YES/*NO value  for whether  to delete  the spooled
                 file  if the  members compare  correctly.   *NO is the
                 default which retains  the spooled file  regardless of
                 the comparison.

                 *YES may  be specified to  delete the spooled  file if
                 there is a 100% comparison.

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

Only files up to 9999 bytes in record length may be compared.

Only files with less than 900 members can be compared.

Files with null capable fields are not supported.

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

The following TAA Tools must be on your system.

      CVTHEX        Convert to hex
      HLRMVMSG      HLL Remove message
      RTVMBRLST     Retrieve member list
      SNDCOMPMSG    Send completion message
      SNDESCMSG     Send escape message
      SNDSTSMSG     Send status message

Implementation
--------------

None, the tool is ready to use.

Objects used by the tool
------------------------

   Object        Type       Attribute      Src member     Src file
   ------        -----      ---------      ----------     -----------

   CMPDBF        *CMD                      TAADBFQ        QATTCMD
   TAADBFQC      *PGM          CLP         TAADBFQC       QATTCL
   TAADBFQR      *PGM          RPG         TAADBFQR       QATTRPG
					

Added to TAA Productivity tools April 1, 1995


Home Page Up to Top