RE: What's in ASP2 ?

Point well taken....

Details .... Details .... I must learn to pay attention to the details ... LOL


Kenneth
Kenneth E. Graap
http://www.linkedin.com/in/kennethgraap


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Thursday, January 07, 2010 11:34 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: What's in ASP2 ?

Graap, Kenneth wrote:

DSPOBJD OBJ(QSYS/*ALL) OBJTYPE(*LIB) OUTPUT(*OUTFILE)
OUTFILE(QTEMP/X)

STRSQL

SELECT ODOBNM, ODASP FROM x WHERE ODASP = 2

Just to be clear, the above is incomplete. Both CRTSAVF and CRTJRNRCV have the ability to create the data\storage area of the objects into a different ASP than the *LIB object; parameter ASP().
Thus an object may exist in the ASP, but not be identified per SQL0100 [no rows found] on that SELECT. However other restrictions exist; omitted, per my not recalling explicit details [though I believe non-library objects in /QSYS.LIB in a user ASP will prevent any CRTLIB, and perhaps vice versa]. IIRC variations on the QDOC and QSPL libraries would appear in the above output to indicate the existence of either /QDLS folders & documents or *OUTQ objects created into a user ASP.

Regards, Chuck
--
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.