Re: Library Description

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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'