Re: is there anyway to find no.of files, no.of pgms,no.of data areas, no of sqlpackages etc

["Steve Landess" <steve_landess@xxxxxxxxxxx>]

Murali -
In the future, please post your questions to the correct forum.  This
question belongs in Midrange-L, where I have posted my reply.  This is NOT
an RPG question.

To answer your question, haven't you been working with the output from the
DSPOBJD command to an outfile?  Use your brain!  You can query the outfile
to get this information.

Example:

1) DSPOBJD OBJ(SJL001/*ALL) OBJTYPE(*ALL) DETAIL(*BASIC) OUTPUT(*OUTFILE)
OUTFILE(OBJECTS/QADSPOBJ)

2) Use Query, Interactive SQL (STRSQL), or Query Management query to run a
summary query over the outfile created by DSPOBJD.

Here is a sample SQL statement that will show you the count of objects by
Library, Object Type, and Object Attribute:

SELECT odlbnm, odobtp, odobat,COUNT(*)
FROM objects/qadspobj
GROUP BY odlbnm,odobtp,odobat
ORDER BY odlbnm,odobtp,odobat

Sample output from running this query
(sorry if things don't line up):

  Library     Object    Object        COUNT ( * )
              Type      Attribute
  SJL001      *BNDDIR                           1
  SJL001      *CMD                              3
  SJL001      *DTAARA                           1
  SJL001      *FILE     DDMF                    1
  SJL001      *FILE     LF                      2
  SJL001      *FILE     PF                     27
  SJL001      *FILE     SAVF                    7
  SJL001      *MODULE   CLE                     2
  SJL001      *MODULE   RPGLE                   8
  SJL001      *PGM      CLE                     7
  SJL001      *PGM      CLLE                    3
  SJL001      *PGM      CLP                    14
  SJL001      *PGM      RPG                     3
  SJL001      *PGM      RPGLE                  28
  SJL001      *QMFORM   QUERY MGR               1
  SJL001      *QMQRY    SQL                     2
  SJL001      *SRVPGM   CLE                     1
  SJL001      *SRVPGM   RPGLE                   1


Here is a sample SQL statement that will show you the count of objects by
Library and Object Type, without regard to Object Attribute:

SELECT odlbnm, odobtp, COUNT(*)
FROM objects/qadspobj
GROUP BY odlbnm,odobtp
ORDER BY odlbnm,odobtp

Sample output from this query:

Library     Object      COUNT ( * )
            Type
SJL001      *BNDDIR               1
SJL001      *CMD                  3
SJL001      *DTAARA               1
SJL001      *FILE                37
SJL001      *MODULE              10
SJL001      *PGM                 55
SJL001      *QMFORM               1
SJL001      *QMQRY                2
SJL001      *SRVPGM               2

Steve Landess
Austin, Texas
(512) 423-0935


----- Original Message ----- 
From: "Murali dhar" <hydchap1@xxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Saturday, July 26, 2003 4:33 AM
Subject: is there anyway to find no.of files, no.of pgms, no.of data
areas,no of sqlpackages etc


> is there anyway i can find out for a given library
> (1)no. of files
> (2)no.of pgm
>   (3)no. of dataareas
> (4)no.of sql packages
> etc etc....
>
>
> ___________________________________________________
> Download the hottest & happening ringtones here!
> OR SMS: Top tone to 7333
> Click here now:
> http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>