Re: Library Description

I'll repeat a suggestion I made because everyone is so focused on DSPOBJD or the cross-reference files and making this hard.

Use PDM -

WRKLIBPDM *ALL

Then F21 gives you a list that looks like this - library name and text description were the desired result, right?

Ba-da-boom! Ba-da-bing!

Vern

5761WDS V6R1M0 080215 V148105 Programming Development Manager - Library list 3/02/11 7:07:38 Page 1
List type . . . . . . . . . . . : *ALL
Library name . . . . . . . . . . : *ALL
Library type . . . . . . . . . . : *ALL
Library Type Owner Created Changed Saved Restored Text
---------- ---------- ---------- -------- -------- -------- -------- ------------------------------------------------
#LIBRARY *PROD QSYS 03/26/08 02/19/11 02/19/11 02/19/11
ASN *PROD QSYS 04/01/08 02/24/11 02/19/11 02/19/11 DATAPROPAGATOR/400
QCAEXP *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QCA400W *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QCBLLE *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QCPPLE *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QCTX *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QDEVTOOLS *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QDIRSRV2 *PROD QDIRSRV 04/01/08 02/19/11 02/19/11 02/19/11
QDOC *PROD QDOC 02/19/11 02/24/11 ******** ******** Document library
QDP4 *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11
QDSNX *PROD QSYS 03/21/08 02/19/11 02/19/11 02/19/11
QFNTCPL *PROD QSYS 02/19/11 02/19/11 02/19/11 02/19/11

On 3/4/2011 2:45 AM, CRPence wrote:

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'