Re: Cross library logicals.

You don't need a fancy audit; the system-maintained file, QSYS/QADBFDEP, maintains a file of cross-library references.

A query over this file will take just a few minutes to run.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx



Query . . . . . . . . . . . . . . . . . PFLFXLIB
Library . . . . . . . . . . . . . . .your.lib.name.here
Query text . . . . . . . . . . . . . . Cross-Library File Dependencies
Query CCSID . . . . . . . . . . . . . . 65535
Query language id . . . . . . . . . . . ENU
Query country or region id . . . . . . US
*** . is the decimal separator character for this query ***
Collating sequence . . . . . . . . . . Hexadecimal
Processing options
Use rounding . . . . . . . . . . . . Yes (default)
Ignore decimal data errors . . . . . No (default)
Ignore substitution warnings . . . . Yes
Use collating for all compares . . . Yes

Selected files
ID File Library Member Record Format
T01 QADBFDEP QSYS *FIRST QDBFDEP

Result fields
Name Expression Column Heading Len Dec
DBFFIL10 substr(DBFFIL,1,10)
DBFFDP10 substr(DBFFDP,1,10)
DBFLB210 substr(DBFLB2,1,10)

Select record tests
AND/OR Field Test Value (Field, Numbers, or 'Characters')

DBFLIB NE DBFLDP
AND DBFLIB NE 'QSYS'

OR DBFLIB NE DBFLDP
AND DBFLDP NLIST 'QSYS2' 'QIWS'

Ordering of selected fields

Field Sort Ascending/ Break Field
Name Priority Descending Level Text

DBFLIB 10 A Dependency Library name
DBFFIL10
DBFLDP 30 A Library name of dependent file
DBFFDP10
DBFTDP Dependency: D-data,V-view,I-indirect
DBFRDP Format name of dependent file
DBFLB210

Report column formatting and summary functions
Summary functions: 1-Total, 2-Average, 3-Minimum, 4-Maximum, 5-Count Overrides
Field Summary Column Dec Null Dec Numeric
Name Functions Spacing Column Headings Len Pos Cap Len Pos Editing

DBFLIB 0 DEPENDENCY 10
LIBRARY
DBFFIL10 2 DBFFIL10 10
DBFLDP 2 DEPENDENT 10
FILE
LIB
DBFFDP10 2 DBFFDP10 10
DBFTDP 2 DEP 1
TYPE
DBFRDP 2 DEPENDENT 10
FORMAT
NAME
DBFLB210 2 DBFLB210 10

Selected output attributes
Output type . . . . . . . . . . . . . . Printer
Form of output . . . . . . . . . . . . Detail
Line wrapping . . . . . . . . . . . . . No
Printer Output
Printer device . . . . . . . . . . . . *PRINT

Report size
Length . . . . . . . . . . . . . . . 66 (default)
Width . . . . . . . . . . . . . . . . 132
Report start line . . . . . . . . . . . 6 (default)
Report end line . . . . . . . . . . . . 60 (default)
Report line spacing . . . . . . . . . . Single space
Print definition . . . . . . . . . . . No

Printer Spooled Output
Spool the output . . . . . . . . . . . (Defaults to value in print file, QPQUPRFIL)
Form type . . . . . . . . . . . . . . . (Defaults to value in print file, QPQUPRFIL)
Copies . . . . . . . . . . . . . . . . 1
Hold . . . . . . . . . . . . . . . . . (Defaults to value in print file, QPQUPRFIL)
Cover Page
Print cover page . . . . . . . . . . . Yes
Cover page title
Cross-Library File Dependencies
Page headings and footings
Print standard page heading . . . . . . Yes
Page heading
Cross-Library File Dependencies
Page footing
* * * * * E N D O F Q U E R Y P R I N T * * * * *