Re: Is there a way to list all objects in a library using SQL

Here's an SQL Scott put out (slightly modified) to list all the objects in
available ASPs



SELECT b.objlongschema, b.objname, b.objtype, b.objattribute, b.objcreated,
b.objsize, b.objtext, b.days_used_count, b.last_used_timestamp,b.* FROM

TABLE (QSYS2.OBJECT_STATISTICS('*ALLUSRAVL ', '*LIB') ) as a,

TABLE (QSYS2.OBJECT_STATISTICS(a.objname, 'ALL') ) AS b

ORDER BY b.OBJSIZE DESC;



Cleary this will need to be run on both systems, then some kind of
comparason done. I like it because is lists object by decending size so I
can find large objects quickly without running RTVDSKINF.





--

Jim Oberholtzer

Agile Technology Architects