TAA Tools

The DSPDB command  allows a simple  method of displaying  an externally
described  data  base file  one  record at  a  time.   This  command is
primarily  intended for  debugging and  problem determination purposes.
It presents a display  using the field names  for the file followed  by
the  value in the  field.   Numeric fields  (except floating  point and
those  greater than  30 digits) are  converted to  a displayable value,
zero suppressed and a decimal point shown.

Using F6,  the TAA  Tool  DSPFLDA may  be  used for  the same  file  to
describe the fields within the file.

The following shows an example of the display:

*                                                                  *
*       DSPDB    File xxxxx    Library yyyy  Record number   4512  *
*                                                                  *
*     CUST    1234   NAME  John Doe and Company                    *
*     ADDR    1200 13th Ave              CITY  New York            *
*     STATE  NY   ZIP  01234   AMTDUE   3000.15                    *
*     YDTSLS  50250.25   NOTES  Never deliver on Sunday beca       *
*     use he is home watching TV                                   *
*                                                                  *

  **   The file name and relative record number appear at the top.

  **   The DDS  field names appear in  highlighted form to the  left of
       a value.

  **   Any  packed or  binary  fields are  converted to  character.   A
       decimal point is shown for non zero decimal fields.

  **   A numeric field and  it's field name always  appear on the  same
       line.   A  character field  greater than  12  characters may  be

The  command defaults  to  start at  the first  record  in a  file.   A
specific   relative  record  number   or  specific  key   may  also  be
requested.  When  a record is  displayed, the rollup/rolldown keys  are
active to move through the file.

The command  operates on a  physical file or  a logical file  which has
only  a single format.  The  file may not have more  than 250 fields to
be displayed.  A maximum size  of 1680 bytes may be displayed which  is
a combination of field  names, values and spacing.   Any excess data is

The  DSPDB command  executes  the DSPFFD  command to  output  the field
definitions to a  file in QTEMP.   An RPG program  then builds a  table
of the output records  and uses the information to  format the display.

If  invalid data is  found in  a decimal  field, a string  of asterisks
will be displayed with the low order digit as 0.

Command parameters                                    *CMD

   FILE          The  qualified name of  the file to  be displayed.  It
                 must be  an externally  described  physical or  single
                 format logical  file.  The library  defaults to *LIBL.

   FROMRCD       The  relative record number to begin  the display.  It
                 defaults to  *START which  means the  first record  in
                 the file.   If the  file is  keyed, this is  the first

   FROMKEY       A  *YES/*NO value  which defaults  to *NO  meaning use
                 the FROMRCD  value.   If *YES  is specified,  the  key
                 fields  for  the  file  are  extracted  and  a  prompt
                 appears for the values to be entered.

   MBR           The member in the file.  The default is *FIRST.

   MINCHRSET     This a  *YES/*NO value that defaults to  *NO.  If *YES
                 is   specified,   only   normal   character   data  is
                 displayed in  character fields.   The purpose of  this
                 is to avoid  the case where certain data  may exist in
                 character  fields that  will be recognized  as control
                 characters by  the display  device.   The letters  A-Z
                 (lower  case  also),  digits   0-9  and  many  special
                 characters  are  considered in  the  minimum character
                 set.  If  *YES is specified,  characters outside  this
                 set will be displayed as asterisks.

Both FROMRCD and FROMKEY cannot be specified.


The command cannot be used with OPNQRYF.


The following TAA Tools must be on your system:

      CRTUSRSPC     Create user space
      DSPFLDA       Display field attributes
      HLRMVMSG      HLL Remove message
      RTVUSRSPCE    Retrieve user space entry
      RTVUSRSPCI    Retrieve user space initialization
      SNDCOMPMSG    Send completion message
      SNDESCMSG     Send escape message
      STRKEY        Start at key value


None, the tool is ready to use.

Objects used by the tool

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

   DSPDB         *CMD                      TAADBFE        QATTCMD
   TAADBFED      *FILE         DSPF        TAADBFED       QATTDDS
   TAADBFEC      *PGM          CLP         TAADBFEC       QATTCL
   TAADBFER      *PGM          RPG         TAADBFER       QATTRPG

Added to TAA Productivity tools April 1, 1995

Home Page Up to Top