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
|
