TAA Tools

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

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

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.


You must have *ALLOBJ special authority to  use a LIB value of *ALL  or


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


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

Added to TAA Productivity tools October 15, 2008

Home Page Up to Top