I use schemas in ACS most of the time, but to throw another option in for green screen - Craig Rutledge has a tool in the JCRCMDS package - JCRFFD that has what you are looking for.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Craig Richards
Sent: Tuesday, August 06, 2019 3:04 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: DSPFFD utility
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
[
https://www.medtronsoftware.com/img/MedtronMinilogo.bmp] Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550
Toll Free: 877-893-2550
https://www.medtronsoftware.com
CONFIDENTIALITY NOTICE
This document and any accompanying this email transmission contain confidential information, belonging to the sender that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, or the employee of agent responsible to deliver it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of these documents is STRICTLY PROHIBITED. If you have received this email in error, please notify the sender immediately to arrange for return or destruction of these documents.
midrange.com
