Re: SYSTABLES and SYSPARTITIONSTAT limitation

Thanks, Rob, for clarifying my early-morning response. Yes, the suggestion was to create a new view over QADBXREF and leave out the DBXREL = 'Y' from the statement - something like that.

I run into authority problems with QADBXREF when I try to run a SELECT against it - it is a very important system file and is strongly protected, as it should be.

Cheers
Vern

On 11/5/2019 12:07 PM, Rob Berendt wrote:

Creating a view over the CRTPF RCDLEN(...) file was not the suggestion. I believe the suggestion was to create a view over the underlying table that SYSTABLES is built over. Or you could just query it directly.

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com -----Original Message----- From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin Taylor Sent: Tuesday, November 5, 2019 1:05 PM To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx> Subject: RE: SYSTABLES and SYSPARTITIONSTAT limitation CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. You can't create a view over an S/36 flat file. I can't say I've tried with one created with CRTPF. -----Original Message----- From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx] Sent: Tuesday, November 05, 2019 8:55 AM To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx> Subject: Re: SYSTABLES and SYSPARTITIONSTAT limitation Hi Carlos SQL-created tables will show up in the system tables. These 2 views - you can DSPFD SYSTABLES or DSPFD SYSPSTAT - one of the elements of the WHERE clause is DBXREL = 'Y' - PFs created with CRTPF and using RCDLEN are not relational, therefore, they are excluded from these views. A person COULD make their own views and include them, I suppose - just use a different name, right? Cheers Vern