RE: SQL issues in program

I see that I introduced confusion by using the grammatically correct but
iSeries-incorrect term "generic name" when I meant Special Value. (Thanks,
Vern, for the prompt.) While *ALL is about as generic as one can get, we
iSeries Folk don't tend to refer to it as a Generic Value. Whether we
should or not, is a topic for another discussion. So, sorry for using that
wrong term. I know better than to do that.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Those who make the worst use of their time are the first to complain of its
shortness."
-- Jean de La Bruyre

While it's true that using a special value for the library, such as
*ALL, *ALLUSR, *LIBL, or *USRLIBL will most likely hit the size
limit of a user space, the OP was referring to one library, and it
seems that everyone else, including you, were as well. This is why
my post was

limited to that.

Bad assumption. I was not.

The best way IMO to handle using any of the special values for
processing multiple libraries is to use two user spaces. One to get
a list of matching libraries, and one to get a list of objects for
each library, one library at a time. ...

Your "best way" sounds reasonable. But it's not necessarily
everyone's "best way." The Open list of Objects may be considered by some

to be a better way.

By the way, IBM's documentation for QUSLOBJ does not indicate that
generic names are allowed for the library name. Because it does not
say that it is allowed, I've never tried to use generic names for
the library list with that API. The approach I mentioned above does
allow generic library names ...

Not sure which doc you are reading. Here is the first part of that
discussion from
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topi
c=%2Fapi
s%2Fquslobj.htm

(I've been using *ALLUSR since the API was introduced (V2R3, I
think).)

*ALL All libraries in the auxiliary storage pools defined by the

auxiliary

storage pool (ASP) control parameter are searched.
*ALLUSR All user libraries in the auxiliary storage pools (ASPs)

defined

by the auxiliary storage pool (ASP) control parameter are searched.
User libraries are all libraries with names that do not begin with the

letter Q.

For information about the libraries included, see *ALLUSR in Generic
library names.

(et cetera. Other libraries mentioned are: *CURLIB, *LIBL, *USRLIBL)

Lighten up a little, Okay? Vern's comment was in jest (or I read it
that way) I responded to that in jest, and now it's gotten way out of
hand. I think the OP has what he needs, or will come back with additional

questions.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If we all said to each other's faces what we say behind each other's
backs, society would be impossible."
-- Honor de Balzac