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

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.