× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.