RE: Count of objects in a library

I see said the blind man. 

My little test lib didn't have much in it so I did not consider that.
Thanks for the feed back, Scott.

Matt Graybiel
NetIQ

****
message: 3
date: Fri, 14 Jul 2006 11:33:45 -0500
from: "Jake M" <jakeroc@xxxxxxxxx>
subject: Re: Count of objects in a library

Good point Scott, I noticed that while getting the count. I appreciate your
input.

Jake.

On 7/14/06, Scott Klement <midrange-l@xxxxxxxxxxxxxxxx> wrote:

Hi Matt,

STRSQL
SELECT COUNT (*) FROM MYLIB/TEST WHERE ODOBAT = 'RPGLE'

My only concern about this is that it'll include *MODULEs, and *SRVPGMs
(and anything else that might have 'RPGLE' as an attribute) in addition to
*PGM objects when it returns the count.

If that's not what the original poster wants, consider adding the object
type to the WHERE clause:

  SELECT COUNT (*) FROM MYLIB/TEST WHERE ODOBAT='RPGLE' AND ODOBTP='*PGM'