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
performer.
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).
DSPALLDTAT FILE(xxx/*ALL) INCEXC(*EXCLUDE)
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
S.
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.
Restrictions
------------
None.
Prerequisites
-------------
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
Implementation
--------------
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
|