DSPDBF DISPLAY DATA BASE FILE MEMBER TAADBFS
The Display Data Base File Member command is a simple front end to
the RUNQRY command. No pre-compiled query need exist. The command
will run using any data base file. The function works best when the
file is externally described.
A typical command is entered as:
DSPDBF allows either displayed or printed output.
If you have the Query/400 product, a record selection option is also
available (using the RUNQRY capability) which provides significant
There are a few important rules to keep in mind when working with the
record selection capability:
** Record selection is allowed for interactive use only. The
command parameter does not perform selection, but only asks if
you want the interactive prompt.
** No sequencing can be specified. The records always appear in
arrival sequence even if a logical file is specified.
** Field names are entered without quotes. Character values are
entered with quotes. Do not enter lower case as a character
value unless the data base contains lower case. There is no
translate table used so the character value must match the
case used in the data base.
** The LIKE function corresponds to the 'contains' function in
some products. The % symbol is used to control the wild card.
Assume you have a file of names in upper case. The following
describes how to perform typical searches:
Field Test Value Description
NAME EQ 'SMITH' Only the SMITH records
NAME LIKE 'SMITH%' SMITH, SMITHERS, SMITHSON etc.
NAME LIKE '%TH%' SMITH, THULE, etc.
The help text for the record selection should lead you thru the
capabilities of this function.
If spooled file output is requested, the spooled file name will be
the name of the file being displayed.
Command parameters *CMD
FILE The qualified file name to be displayed. The
library entry defaults to *LIBL.
MBR The member to be displayed. The default is *FIRST.
RCDSLT Whether record selection is needed. The default is
*NO. *YES is only valid when entered interactively.
A *YES is only valid if the Query/400 5716-QU1 is
installed (the QQRYLIB exists).
OUTPUT This has the same definition as normal DSP commands
where * is the default and allows an interactive
display or a spooled file if in batch. *PRINT may
be entered if spooled file output is needed when
To use the record selection function, you must have the product
Query/400 (QU1) on your system.
The following TAA Tools must be on your system:
SNDCOMPMSG Send completion message
SNDESCMSG Send escape message
None, the tool is ready to use.
Objects used by the tool
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
DSPDBF *CMD TAADBFS QATTCMD
TAADBFSC *PGM CLP TAADBFSC QATTCL
Added to TAA Productivity tools April 1, 1995