|
... but ACS shows you exactly the information you want Open Schemas--
--> Select your Schema --> Select your Object type (in you case it
might be table, view or index) --> Position on the table (you even can
filter the tables) --> and then look at the context menu on your table:
Definition will show you all columns with short and long names, data
types, length, CCSID, whether it is NULL capable or not, whether it
has a default value and what the default value is, whether it is an
identity column or not...
It also shows you the key and check constraints.
Work with shows among others all dependent objects.
I personally use FileAccess from the SSS Syntax System Services. (BTW
a very good tool) In the US it is sold by OASIS:
https://www.oasis400.com/fa400
But to be honest I use more and more ACS instead off FileAccess.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars."
(Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training
them and keeping them!"
„Train people well enough so they can leave, treat them well enough so
they don't want to.“ (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Craig Richards
Sent: Dienstag, 6. August 2019 11:21
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: DSPFFD utility
Hi Birgitta,
Thanks as always for your reply.
I have used both the ACS schema and SYSCOLUMNS in the past for various
reasons.
But I was really thinking about a simple command and succint UI to
show the fields, types, text and keys.
SYSCOLUMNS does have most of what I require (except the key
information) but it's not particularly convenient to jump into STRSQL
and start running Selects over SYSCOLUMNS.
So I'd be back to writing some kind of utility to make it
cleaner/simpler I'm more than capable of doing that, but I was just
curious to see what most people use these days for retrieving that kind of information.
It's fairly common for me to want to look at a file to remind myself
of the spelling of a field, or its type or length.
Mostly I use WRKDBF which is what my client site has, but it does
annoy me when it fails on the files with CLOBS and I have to resort to DSPFFD.
A while ago I did try emailing Bill Reger to see if I could fix the
overflow problem in WRKBF but I didn't get a reply.
thanks and regards,
Craig
On Tue, 6 Aug 2019 at 09:42, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:
Have you ever thought about using ACS (Access Client Solutions)--
Schemas to get your file information?
Why is SYSCOLUMNS no option for you?
It contains all information for all columns in all files.
To get all information about a specific file you only need a select
statement:
SELECT *
FROM QSYS2.SYSCOLUMNS
WHERE TABLE_NAME = 'YOURFILE'
AND TABLE_SCHEMA = 'YOURLIB';
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars."
(Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not
training them and keeping them!"
„Train people well enough so they can leave, treat them well enough
so they don't want to.“ (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf
Of Craig Richards
Sent: Dienstag, 6. August 2019 10:04
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
--
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
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
--
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
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
