RE: SYSTABLES and SYSPARTITIONSTAT limitation

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

On 11/5/2019 8:38 AM, Carlos wrote:

What about the files created with the SQL create table?
Thanks
CARLOS


Sent from my iPhone

On Nov 5, 2019, at 8:48 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

Flat files don't show up in iACS Schemas, so I'm not at all surprised.



-----Original Message-----
From: smith5646midrange@xxxxxxxxx
[mailto:smith5646midrange@xxxxxxxxx]
Sent: Tuesday, November 05, 2019 7:34 AM
To: 'Midrange Systems Technical Discussion'
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: SYSTABLES and SYSPARTITIONSTAT limitation

I was just curious how many people know that these two "tables" do not return files created via CRTPF specifying the RCDLEN instead of DDS.


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