Re: DSPFFD utility

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Craig

In my world so far, DSPFFD is a command provided by IBM - what is the 
utility? I found something called that on a Search400 link from 2001, 
probably have to sign in to see it all.

Thanks
Vern

On 8/6/2019 3:04 AM, Craig Richards wrote:
> DSPFFD with its "Display Spooled File" UI is not very convenient for
> quickly scanning the fields and types on a file. And obviously it doesn't
> show the database keys.
>
> Most places I've worked use 3rd Party utilities like Synon YWRKF or some
> in-house solution.
>
> The place I'm working now uses WRKDBF but that doesn't seem to have been
> maintained in a bunch of years and it falls over with an overflow error on
> some files which contain CLOBs.
>
> I just had a quick look at Peter Colpaert's WRKFLD which is downloadable
> from http://www.think400.dk/downloads.htm but I'm not sure that's quite
> what I'm after.
>
> I don't want an editor or anything fancy, but something to show fields,
> types, keys and text would be nice.
> I know I could write something using the DB APIs or some of the QSYS2
> tables like SYSCOLUMNS but at the moment I don't really have the time or
> inclination.
>
> I wondered what most other people are using for this kind of thing?
>
> regards,
> Craig