I did not find it in QADBXREF unless I overlooked it.
Guess I'll do the hard way for now. I'm out of time.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon
Hamberg
Sent: Friday, January 29, 2021 11:00 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Retrieving record format via SQL
This might be worth an RFE request - I think the info might be in a table
called QADBXREF, but we don't generally have authority to it - the
SQL* and SYS* tables are often views, actually, over those QADB* files.
Trouble is, SQL-the-standard- knows nothing about formats, nor about members
and RRNs and the like that are part of the implementation on IBM i - SQL
language really doesn't care about low-level implementation, so long as some
layer in between converts the physical part into relational structures and
operations.
Whew! Time to go back to bed after that!
Cheers
Vern
On 1/29/2021 8:48 AM, smith5646midrange@xxxxxxxxx wrote:
Does anyone know where I can find the record format using SQL? I know
I can do DSPFD to *OUTFILE and select from it but I'd rather do it the
easy way, assuming it exists somewhere in a table already.
--
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@xxxxxxxxxxxxxxxxxxxx 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.