TAA Tools

The Display  All Data Types  command lists or  displays the data  types
that  are  to be  included  or excluded  from  a file  or  files.   For
example,  you can  display all fields  that have a  W (variable length)
data type for files in a library.

If many  files are to  be checked,  DSPALLDTAT command will  be a  slow

If a  file cannot be processed by  DSPFFD (such as some  DDM files), it
is bypassed.

A  typical command would be  to display all fields  that are other than
A (Character), P (Packed), or S (signed).

                          DTATYP(A P S)

A listing would  be displayed  with one  record for each  field in  all
files in the  named library that have a  data type other than  A, P, or

DSPALLDTAT escape messages you can monitor for

      TAA9891    No file objects met the selection criteria.

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

DSPALLDTAT Command parameters                         *CMD

   FILE          The  qualified name  of  the file  to be  checked.   A
                 specific file, a  generic name, or  the special  value
                 *ALL may be specified.

                 The  library  qualifier  defaults  to   *USRLIBL.    A
                 specific library or *CURLIB may also be used.

   INCEXC        Whether  to include or  exclude the named  data types.
                 *INCLUDE  should  be  used  to  'include'.    *EXCLUDE
                 should be used to 'exclude'.

                 If DTATYP(*ALL)  is  specified, INCEXC(*INCLUDE)  must
                 be used.

   DTATYP        The  list of data  types to  be included  or excluded.
                 At  least one data type or *ALL  must be specified.  A
                 maximum of 26 may be specified.

                 The following are supported:

                 *ALL = All data types
                    A = Character
                    B = Binary
                    D = Digits only
                    E = Either DBCS or alphanumeric
                    F = Floating point
                    G = Graphic
                    H = Hexadecimal
                    I = Inhibit entry
                    J = DBCS data only
                    L = Date
                    M = Numeric only
                    N = Numeric shift
                    O = Open for both DBCS and alphanumeric
                    P = Packed
                    S = Signed (zoned decimal)
                    T = Time
                    W = Variable length
                    X = Alphabetic only
                    Y = Numeric only
                    Z = Time stamp
                    1 = BLOB
                    2 = CLOB
                    3 = Open CLOB
                    4 = Data base CLOBJ
                    5 = Data link
                    6 = Open data link

   FILETYPE      The file type to be  processed.  *ALL is the  default.
                 A maximum  of 4  may be  entered from  the types  *PF,
                 *LF, *PRTF, or *DSPF.

   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.




The following TAA Tools must be on your system:

     EDTVAR          Edit variable
     EXTLST2         Extract list 2
     RTVOBJD2        Retrieve object description 2
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     SNDESCMSG       Send escape message
     SNDSTSMSG       Send status message


None, the tool is ready to use.

Objects used by the tool

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

   DSPALLDTAT    *CMD                   TAADBNS       QATTCMD
   TAADBNSC      *PGM       CLP         TAADBNSC      QATTCL
   TAADBNSR      *PGM       RPG         TAADBNSR      QATTRPG

Added to TAA Productivity tools January 15, 2014

Home Page Up to Top