TAA Tools
DSPFLDUSE       DISPLAY FIELD USE                      TAAWHRC

The  Display Field  Use tool  allows  a 'where  used'  function of  the
fields  in externally described  files.   The Display  command provides
access  to the definition of a field and  the files that use the field.
The CVTFLDUSE command must  be used periodically to convert  the system
DSPFFD outfile information to files used by DSPFLDUSE.

You begin by creating the required FLDUSEx files in a library.

            CRTFLDUSE    FLDUSELIB(xxx)

You  then convert the  information from  externally described  files in
named libraries to the created files such as:

            CVTFLDUSE    LIB(abc def ghi) FLDUSEPLIB(xxx)

The  CVTFLDUSE command  must be used  to periodically  refresh the data
in the  FLDUSEx files.   If many  files must  be converted,  this is  a
slow  running function  and  should  be submitted  to  batch.   A  good
solution  is have  a scheduled job  (such as  weekly) that runs  at off
peak hours.

You are then ready to display a field such as:

            DSPFLDUSE    FIELD(yyy) FLDUSEPLIB(xxx)

A subfile will appear with one line  for each file that that the  field
exists in.   A basic  option exists to  display more information  about
the  field.    Special options  exist  for  data  base  file fields  to
display  more detail  field information or  the entire  format that the
field exists in.

Convert selection criteria
--------------------------

You can specify the following on the CVTFLDUSE command.

  **   Up to 300 library  names including generic names or  the special
       values *ALLUSR or *USRLIBL.

  **   Specific file  types such as PF or  LF.  The default  is for all
       externally described files.

  **   The type of library (*PROD or *TEST).

  **   Up to 300 library names to omit.

Authorization required
----------------------

The  CRTFLDUSE command creates the files  used by DSPFLDUSE.  CRTFLDUSE
provides the AUT  parameter which  defaults to *USE  authority for  the
*PUBLIC user.  This allows the use of DSPFLDUSE by the public.

CVTFLDUSE requires clearing  the existing data in the  FLDUSEP file and
therefore requires:

            *OBJMGT
            *OBJOPR
            *READ
            *ADD
            *DLT

DLTFLDUSE requires *OBJEXIST authority to delete the files.

OMITLIB Data Area in TAASECURE
------------------------------

The  OMITLIB  data area  in  TAASECURE  is used  in  a  prompt override
program  to  fill  in  the  OMITLIB  parameter.    The  data  area   is
initialized  to TAATOOL  when  the  TAA  Productivity Tools  are  first
shipped.

You  may  add  other   libraries  that  you  want  to  bypass  in  your
installation.   For example, if you  have other products on your system
that should not  be included,  you could add  the product libraries  to
the list.

An *ALLOBJ special authority user could enter the command:

             EDTCONARR     DTAARA(TAASECURE/OMITLIB)

The list  of libraries can then  be maintained.  The  OMITLIB data area
is  used by other tools where you  would generally want to omit certain
libraries.

Escape messages you can monitor for
-----------------------------------

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

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

   FLDUSEPLIB    The library  to  contain  the  files  needed  for  the
                 DSPFLDUSE tool.   The  physical file  FLDUSEP and  the
                 logical file FLDUSEL will be created.

   SRCLIB        The  source  library  to  use  for  the  QATTDDS  file
                 source.  The default  is *TAAARC.   If a full  license
                 exists, the source is  used from the TAA Archive.   If
                 a  demonstration license  exists, the  source  is used
                 from the QATTDDS file in the TAATOOL library.

                 A  specific user library may  be named, but the source
                 file must be QATTDDS.

   AUT           The  authority  to the  physical  file  that  will  be
                 created.   *USE is the  default.  With *USE,  any user
                 can use DSPFLDUSE to display information.

                 CVTFLDUSE   requires   the  user   to   have  *OBJMGT,
                 *OBJOPR, *READ, *ADD, and *DLT authority.

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

   FLDUSEPLIB    The library which contains the FLDUSEx files

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

   LIB           The library or libraries to  be converted.  Up to  300
                 names  (including  generic)  may  be  entered  or  the
                 special values *ALLUSR or *USRLIBL.

   FLDUSEPLIB    The  library which  contains the  FLDUSEx files.   The
                 default is *LIBL.  *CURLIB may be specified.

   REPLACE       A *YES/*NO parameter for  whether to replace the  data
                 in the FLDUSEP file.  *YES is the default.

                 *NO  should be  used  if you  are  adding to  existing
                 data using another CVTFLDUSE command.

   FILTYPE       The  file type to  convert.   The default is  *ALL for
                 all  file  types  that  contain  externally  described
                 data.  If  a file was  created without DDS source,  it
                 is   automatically  bypassed.      Source  files   are
                 implicitly bypassed.

                 One  or more of a list of  file types may be specified
                 *PF,  *PF38,  *LF,   *LF38,  *PRTF,  *PRTF38,   *DSPF,
                 *DSPF38, or *ICF.

   LIBTYPE       The library  type to  convert.   The default  is *ALL.
                 Either *PROD or *TEST may be specified.

   INCINDFLD     A  *YES/*NO parameter  for  whether to  include fields
                 for indicators (such  as *IN31).   The default is  *NO
                 to exclude indicator fields.

                 Device  files  (such  as  *DSPF)  may  have  indicator
                 fields  which  begin  with  an  * such  as  *IN31  for
                 indicator   31.     In  most   cases  these   are  not
                 meaningful to  cross reference  and using the  default
                 eliminates them from the file.

                 *YES may be specified to include indicator fields.

   OMITLIB       The  library  or  libraries   to  omit.    Up  to  300
                 libraries may be entered.  The default is *NONE.

                 This  allows a  LIB value such  as *ALLUSR  and a list
                 of libraries that you do not want included.

                 A prompt override program  exists so that the  OMITLIB
                 data  area in  TAASECURE is  used.   See the  previous
                 discussion for how to use this data area.

                 If you  are processing *ALLUSR or  *USRLIBL, you would
                 normally want to omit the TAATOOL library.

                 If  a  library  name   is  entered,  it  must   exist.
                 However, there  is no check  made to determine  if the
                 library  would have  been converted  by  the libraries
                 specified  for  the LIB  parameter.   For  example, if
                 LIB(ABC DEF)  is  specified, it  is  not an  error  to
                 specify OMITLIB(GHI).

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

   FIELD         The 'field  name' to position to in  the FLDUSEx file.
                 If  no field is entered, the  display appears with the
                 first  field  in  the   file.    The  display   allows
                 positioning to any field name.

   FLDUSEPLIB    The library  which contains  the FLDUSEx  files.   The
                 default is *LIBL.  *CURLIB may be specified.

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

You must  be authorized to the files to  be converted to use CVTFLDUSE.

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

The following TAA Tools must be on your system:

     ADJVAR          Adjust variable
     CHKACTOBJ       Check active object
     CHKDUPLST       Check duplicate list
     CMPLSTPARM      Compare list parameter
     CPYTAADDS       TAA Archive
     DSPFLDA         Display field attributes
     DSPFMT          Display format
     EDTVAR          Edit variable
     EXTLST2         Extract list 2
     FILEFDBCK       File feedback
     HLRMVMSG        HLL Remove message
     RTVDBFA         Retrieve data base file attributes
     RTVDSPFA        Retrieve display file attributes
     RTVDTATYPD      Retrieve data type description
     RTVPRTFA        Retrieve printer file attributes
     RTVSYSDAT       Retrieve system date
     SNDCOMPMSG      Send completion message
     SNDDIAGMSG      Send diagnostic message
     SNDESCMSG       Send escape message
     SNDJLGMSG       Send job log message
     SNDSTSMSG       Send status message
     UPDPFILE        Update PFILE keyword

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

None, the tool is ready to use.

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

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

   DSPFLDUSE     *CMD                   TAAWHRC       QATTCMD
   CRTFLDUSE     *CMD                   TAAWHRC2      QATTCMD
   DLTFLDUSE     *CMD                   TAAWHRC3      QATTCMD
   CVTFLDUSE     *CMD                   TAAWHRC4      QATTCMD
   TAAWHRCC      *PGM       CLP         TAAWHRCC      QATTCL
   TAAWHRCC2     *PGM       CLP         TAAWHRCC2     QATTCL
   TAAWHRCC3     *PGM       CLP         TAAWHRCC3     QATTCL
   TAAWHRCC4     *PGM       CLP         TAAWHRCC4     QATTCL
   TAAWHRCC10    *PGM       CLP         TAAWHRCC10    QATTCL
   TAAWHRCC14    *PGM       CLP         TAAWHRCC14    QATTCL
   TAAWHRCR      *PGM       RPG         TAAWHRCR      QATTRPG
   TAAWHRCD      *FILE      DSPF        TAAWHRCD      QATTDDS
   TAAWHRCP      *FILE      PF          TAAWHRCP      QATTDDS
   TAAWHRCL      *FILE      LF          TAAWHRCL      QATTDDS

TAAWRHCP is  used  to create  FLDUSEP.    TAAWHRCL is  used  to  create
FLDUSEL.  The FLDUSEx files exist in user libraries.


Structure
---------

DSPFLDUSE   Cmd
   TAAWHRCC   CL pgm
     TAAWHRCR   RPG Pgm
       TAAWHRCD   Display file
       TAAWHRCC10    CL pgm for DSPxxx options

CRTFLDUSE   Cmd
   TAAWHRCC2   CL pgm

DLTFLDUSE   Cmd
   TAAWHRCC3   CL pgm

CVTFLDUSE   Cmd      The prompt override pgm is TAASREEC10
   TAAWHRCC4   CL pgm
     TAAWHRCC14  CL pgm
					

Added to TAA Productivity tools August 15, 2001


Home Page Up to Top