The Display Data Base File Allow Functions command displays or lists
the options for 'allow update' and 'allow delete' that may be set for
physical data base files. A listing is produced of either all files
or only those which have specified either of the 'allow' options.
The intent of DSPDBFALW is to allow a review of these options.
You must have *ALLOBJ special authority to use a LIB value of *ALL or
*ALLUSR.
A typical command would be:
DSPDBFALW LIB(xxx)
All physical files in the named library would be accessed. If either
the 'allow update' or 'allow delete' attributes are set to *NO, the
file would be listed. A display version of the listing would appear.
System support
--------------
The ALWUPD and ALWDLT parameters on CRTPF may be used to set the
attributes. The default is *YES. These options do not exist on
CHGPF or CHGPFM.
The function supersedes security authorizations meaning that even if
a user is authorized to update and delete, the system will prevent
the action.
Internally, the system also supports the capability to prevent
writing new records into a file or reading a file. These attributes
can be seen with DSPFD (and are output to the outfile). The system
may internally set some of these attributes. For example, a joined
logical file cannot be updated, deleted, or written to.
It would be possible to prevent writing to a file using the standard
authorization function of not allowing the *ADD right for any user
(including the owner). However, the owner or an *ALLOBJ user could
change the authorization.
DSPDBFALW escape messages you can monitor for
---------------------------------------------
TAA9891 No physical files exist to be accessed
Escape messages from based on functions will be re-sent.
DSPDBFALW Command parameters *CMD
----------------------------
LIB The library name containing the physical files. Up
to 300 names may be entered for single libraries or
generic library names. A single value for *CURLIB,
*USRLIBL, *ALL, or *ALLUSR may be used. See also
the OMITLIB parameter.
FILE The file name to be processed.
*ALL is the default for all physical files specified
for the LIB parameter. A single file name or a
generic name may be entered.
LIBTYPE The library type to be processed. *ALL is the
default. *PROD or *TEST may be specified.
DETAIL An option for whether to list all files or only
those that have the 'allow' options.
*ONLY is the default which means list only those
physical files that have either the 'allow update'
or 'allow delete' attribute set to No.
*ALL may be specified to list all physical files.
OMITLIB A list of up to 300 libraries or generic library
names that should be omitted. *NONE is the default.
An omit list may not be entered for LIB(*CURLIB).
No check occurs to see if an omit library would have
been selected. For example, if LIB(*USRLIBL) is
entered with OMITLIB(ABC) and library ABC is not on
the library list, no error occurs.
OUTPUT How to output the results. * is the default to
display the spooled file if the command is entered
interactively. The spooled file is deleted after it
is displayed.
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 LIB value of *ALL or
*ALLUSR.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKALLOBJ Check *ALLOBJ special authority
CHKGENERC Check generic
CVTLIBOBJD Convert library object description
EDTVAR Edit variable
EXTLST2 Extract list 2
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
SNDESCINF Send escape information
SNDESCMSG Send escape message
SNDJLGMSG Send job log 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
------ ---- --------- ---------- ----------
DSPDBFALW *CMD TAADBMA QATTCMD
TAADBMAC *PGM CLP TAADBMAC QATTCL
TAADBMAR *PGM RPG TAADBMAR QATTRPG
|