RE: Count of objects in a library

["Matt Graybiel" <matt@xxxxxxxxxxxx>]

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'