The Scan Field Type command scans data base files in one or more
libraries for one or more field types. For example, you can
determine which files have field types for date (L), timestamp (Z),
variable length (W), or BLOB (1).
A typical command would be:
SCNFLDTYP FLDTYP(*BIN *VARLEN) LIB(xxx)
By default, only PF/PF38 file types are scanned for. One line for
each data base physical file would be printed with the number of
fields in each. The format of each file would be extracted and
scanned for binary or variable length field types. For each field
type found, a line would be printed.
Only data files are processed (not source files).
If a file has more than 998 fields, it is flagged and not scanned.
SCNFLDTYP escape messages you can monitor for
---------------------------------------------
None. Escape messages from based on functions will be re-sent.
Command parameters *CMD
------------------
FLDTYP A list of up to 10 field types to be scanned for.
See the command prompt for the valid values such as
*BIN, *PACKED, *VARLEN, etc.
LIB The library or libraries to be scanned. A list of
to 300 libraries may be entered. A generic name may
be used or the special values *LIBL, *USRLIBL,
*CURLIB, *ALL, or *ALLUSR.
You must have *ALLOBJ special authority to specify
*ALL or *ALLUSR.
DBFTYPE The DBF file type to process. The default is *PF
for all physical file types (includes both PF and TB
types).
*LF may be entered for all logical file types
(includes both LF and VW types).
*ALL may be entered for both *PF and *LF types.
OMITLIB A list of up to 300 libraries to be omitted.
An omit list may not be entered for LIB(*CURLIB).
Any library entered is checked for existence.
No check occurs to see if an omit library would have
been selected. For example, if LIB(*LIBL) is
entered with OMITLIB(ABC) and library ABC is not on
the library list, no error occurs.
OUTPUT How the output should be displayed. * means a
display appears if the command is used
interactively. If the command is run in batch or
*PRINT is specified, a spooled file is output.
Restrictions
------------
If a file has more than 998 fields, it is flagged and not scanned.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKALLOBJ Check *ALLOBJ special authority
CHKDUPLST Check duplicate list
CHKGENERC Check generic
CHKGENOBJ Check generic object
CHKOBJ3 Check object 3
CMPLSTPARM Compare list parameters
CRTDUPPF Create duplicate physical file
CVTLIBDBF Convert library data base files
EXTLST Extract list
EXTLST2 Extract list 2
RTVDBFA Retrieve data base file attributes
RTVFLDARR Retrieve field array
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
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
------ ---- --------- ---------- ----------
SCNFLDTYP *CMD TAADBJZ QATTCMD
TAADBJZC *PGM CLP TAADBJZC QATTCL
TAADBJZC2 *PGM CLP TAADBJZC2 QATTCL
TAADBJZR *PGM RPG TAADBJZR QATTRPG
|
