TAA Tools

The Display  Data Base  File Member command  is a  simple front  end to
the  RUNQRY command.   No pre-compiled query  need exist.   The command
will  run using any data  base file.  The  function works best when the
file is externally described.

A typical command is entered as:

        DSPDBF    FILE(xxxx)

DSPDBF allows either displayed or printed output.

If you have  the Query/400 product, a  record selection option is  also
available  (using the  RUNQRY  capability)  which provides  significant

There are  a few important rules to keep  in mind when working with the
record selection capability:

  **   Record selection  is  allowed for  interactive  use only.    The
       command parameter does  not perform selection, but  only asks if
       you want the interactive prompt.

  **   No  sequencing can be specified.   The records  always appear in
       arrival sequence even if a logical file is specified.

  **   Field names are  entered without quotes.   Character values  are
       entered with  quotes.  Do  not enter lower  case as a  character
       value  unless the data  base contains lower  case.  There  is no
       translate  table  used so  the  character value  must  match the
       case used in the data base.

  **   The LIKE  function  corresponds to  the  'contains' function  in
       some products.   The % symbol is used to  control the wild card.
       Assume  you have a file  of names in upper  case.  The following
       describes how to perform typical searches:

         Field   Test   Value          Description

         NAME    EQ     'SMITH'        Only the SMITH records
         NAME    LIKE   'SMITH%'       SMITH, SMITHERS, SMITHSON etc.
         NAME    LIKE   '%TH%'         SMITH, THULE, etc.

The help  text  for  the record  selection  should lead  you  thru  the
capabilities of this function.

If spooled  file output  is requested,  the spooled  file name will  be
the name of the file being displayed.

Command parameters                                    *CMD

   FILE          The  qualified   file  name  to  be  displayed.    The
                 library entry defaults to *LIBL.

   MBR           The member to  be displayed.   The default is  *FIRST.

   RCDSLT        Whether record  selection is needed.   The  default is
                 *NO.   *YES is only valid  when entered interactively.
                 A  *YES  is only  valid if  the Query/400  5716-QU1 is
                 installed (the QQRYLIB exists).

   OUTPUT        This has the  same definition  as normal DSP  commands
                 where  *  is the  default  and  allows an  interactive
                 display  or a  spooled file if  in batch.   *PRINT may
                 be entered  if  spooled  file output  is  needed  when
                 used interactively.


To  use  the record  selection  function,  you  must have  the  product
Query/400 (QU1) on your system.


The following TAA Tools must be on your system:

           SNDCOMPMSG      Send completion message
           SNDESCMSG       Send escape message


None, the tool is ready to use.

Objects used by the tool

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

   DSPDBF        *CMD                       TAADBFS       QATTCMD
   TAADBFSC      *PGM           CLP         TAADBFSC      QATTCL

Added to TAA Productivity tools April 1, 1995

Home Page Up to Top