Re: [Bulk] Re: Getting DDS for a DDL Generated File (or convince me its unnecessary)

Ok pub1.de is actually V5R3 not V5R4. Apparently they are replacing it with
7.2 soon. Thats good news.

On Thu, Jan 21, 2016 at 12:02 PM Mark S Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

Justin:

It could be an authority issue ... on my V5R4 system, *PUBLIC has *USE
and *READ authority to all of those tables and views in QSYS2.

Mark

> On 1/21/2016 11:49 AM, Justin Dearing wrote:

On Thu, Jan 21, 2016 at 11:38 AM Mark S Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

Justin:

Try it this way:

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER
FROM qsys2/syspartitionstat WHERE ...

That worked for me on V5R4,

I tried with the . and the '/'. I got this: [SQL0204] SYSPARTITIONSTAT

in

QSYS2 type *FILE not found. [SQL State=42704, DB Errorcode=-204]

I'll ask the owner of the box.

Thanks.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.