TAA Tools
DSPDBFJOIN      DISPLAY DATA BASE JOIN FILES           TAADBNY

The Display  Data  Base Join  Files command  displays or  lists one  or
more  join files  in  one or  more  libraries.   The From  and  To file
information  is provided along with the name  of the keys in each file.

You must have *ALLOBJ special  authority to use a library  qualifier of
*ALL or *ALLUSR.

A typical command would be:

              DSPDBFJOIN FILE(ABC/*ALL)

All join  files in  library ABC  would be displayed  with one  line for
each file that is joined and a separate line for each key.

DSPDBFJOIN escape messages you can monitor for
----------------------------------------------

None.  Escape messages from based on functions will be re-sent.

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

   FILE          The  qualified name of the join  file to be displayed.
                 The file  name may  be generic  or  the special  value
                 *ALL.

                 *LIBL  is  the  default  for  the  library  name.    A
                 specific  library, *CURLIB,  *ALL,  or *ALLUSR  may be
                 entered.

   OUTPUT        How to  output  the results.    * is  the  default  to
                 display the  spooled file  if the  command is  entered
                 interactively.   If the  display is ended  with F3/F12
                 or  the Enter key,  the spooled file  is deleted after
                 it is  displayed.   To  retain the  spooled file,  you
                 may use  the the System Request  'Cancel' function and
                 the spooled file will exist in a HLD status.

                 If  the  command  is entered  in  batch  or  *PRINT is
                 specified, the spooled  file is  output and  retained.

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

You must have  *ALLOBJ special authority to use a  library qualifier of
*ALL or *ALLUSR.

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

The following TAA Tools must be on your system:

     CHKALLOBJ       Check *ALLOBJ special authority
     CVTLIBDBF       Convert library data base files
     RSNLSTMSG       Resend last message
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     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
   ------        ----    ---------      ----------    ----------

   DSPDBFJOIN    *CMD                   TAADBNY       QATTCMD
   TAADBNYC      *PGM       CLP         TAADBNYC      QATTCL
   TAADBNYR      *PGM       RPG         TAADBNYR      QATTRPG
					

Added to TAA Productivity tools January 15, 2014


Home Page Up to Top