Re: DSPFFD utility

Hi Vern,

I'm not really talking about a specific utility, but I can give you
examples:

YWRKF - a utility that used to come as part of the SYNON application:
https://en.wikipedia.org/wiki/Synon
WRKDBF - a popular but no longer maintained utility: http://www.wrkdbf.com/

I recall using something called DspRcdFmt that I may even have written
myself at a previous client's site.
If I did, I didn't keep the source code.

The point is that the system supplied DSPFFD uses the Display Spooled File
UI, and it's not a very convenient output form.

I've been playing Birgitta's suggestion of ACS schema a bit this morning
and it's ok but I'm finding sometimes when I click "Definition" from the
context menu of a table, it responds in about 5 seconds, other times it
takes over a minute. I'll persevere for a while but I'm already thinking my
life is too short for that.

Don has kindly offered to send me the source of their in-house solution but
I see Bradley has also kindly given me a link to lsttffd (which actually
rings a bell also although I couldn't immediate say if I'm remembering
using Bradley's utility at a previous site or if it was just a utility that
I or someone else wrote with that name ) so I think I'll check that out.

best regards,
Craig



On Tue, 6 Aug 2019 at 13:31, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com