× 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.



Select the table and right click - WORK WITH -> INDEXES.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Mark Murphy
Sent: Tuesday, August 06, 2019 7:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: DSPFFD utility

Unfortunately, ACS does not know about Physical and Logical files. It does not show key columns for either. Unless I am missing something.

On Tue, Aug 6, 2019 at 6:01 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

... 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

--
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.

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.