Re: Library Description

[CRPence <CRPbottle@xxxxxxxxx>]

  I do not expect that selection of TEXT(), effectively that of a 
randomly chosen database or DDM device *FILE, qualifies as "library 
text" ;-) nor that any library without at least one database or DDM 
device *FILE would ever be selected\presented by either of the quoted 
queries.  Unfortunately the System Database Cross-Reference, the 
*DBXREF, does [or by 6.1 still] did not have a file tracking *LIB 
objects, only the SCHEMAS() UDTF in SYSIBM offered by the SQL... which I 
do not recall ever having functioned [for me; for whatever reason].

Regards, Chuck

On 3/3/11 2:09 PM, John Rusling wrote:
> Ahhh -- add dbxtxt field for the library text.
> John Rusling on Thursday, March 03, 2011 4:07 PM wrote:
>
> > From my scrapbook -
>
> <=>  - List of All Libraries--
> SELECT DISTINCT dbxlib, dbxown
>    FROM qsys/qadbxatr
>
> <=>  - List of All non-system (User) Libraries--
> SELECT DISTINCT dbxlib, dbxown
>    FROM qsys/qadbxatr
>    WHERE dbxown<>  'QSYS'