Re: Command to list all logicals and their key fields for a physical file?

On 09-Feb-2012 08:16 , Pat Barber wrote:

The only command we have native is DSPDBR

DSPDBR FILE(TCS/HISTORY) OUTPUT(*OUTFILE) OUTFILE(TCS/HISTDBR)

RCDFMT(*ALL)

The resulting file has all logicals but no key info...

FWiW:

The above would include only those LF which share [depend on] the format(s) of the file HISTORY in TCS. If that FILE() shares formats with any PF, then those physical files would also be listed in the output file. If that FILE() has dependent logical files that do not share the format(s), then those logical file would *not* be listed in the output file.

Although the syntax for the DSPDBR command does not allow the explicitly specified request, the effect of the request to "DSPDBR FILE(TCS/HISTORY) RCDFMT(*NONE) MBR(*NONE)" is what is desired for listing all dependent logical files of the file HISTORY in TCS. The syntax that is allowed, is the request to "DSPDBR FILE(TCS/HISTORY) /* RCDFMT(*N) */ MBR(*NONE)"; i.e. omit the RCDFMT() parameter when not interested in Record Format relationships\dependencies.

Regards, Chuck