RE: SYSTABLES and SYSPARTITIONSTAT limitation

[Justin Taylor <JUSTIN@xxxxxxxxxxxxx>]

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