RE: No. of objects in a library, I want all the list to be print edin an xl sheet

Murali

if you do a dspobjd to *OUTFILE, then transfer the outfile to a csv

DSPOBJD OBJ(LIBNAME/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE)
OUTFILE(MYLIB/MYFILE)

then use file transfer to transfer mylib/myfile to a csv.

Kevin.

-----Original Message-----
From: Murali dhar [mailto:hydchap1@xxxxxxxxxxxxxx]
Sent: 26 June 2003 12:00
To: Midrange Systems Technical Discussion
Subject: No. of objects in a library, I want all the list to be printed
in an xl sheet


Hai friends,
Thanks so much for ur valuable answers on my question...I ve got 
more than 20000 objects in one production library on which i ve to 
do analysis...I want to prepare an xl sheet with this 
objects...instead of entering manually each object into xlsheet, 
is there anyway i can print this spool file directly onto an xl 
sheet..Please kindly provide me steps how to do this?
Thanks&Best Regards,
Murali

On Thu, 26 Jun 2003 Jones, John (US) wrote :
>Of course if you don't need the info in a program, DSPLIB libname 
>and
>look in the upper right corner of the screen.
>
>-----Original Message-----
> From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx]
>Sent: Wednesday, June 25, 2003 2:59 PM
>To: Midrange Systems Technical Discussion
>Subject: Re: No. of objects ina library
>
>
>Murali
>
>Easy way is
>
>dsplib libname output(*print)
>
>The number of libs is at the bottom of the report.
>
>There's also an API for retrieving library information.
>
>HTH
>
>Vern
>
>At 05:35 AM 6/25/2003 +0000, you wrote:
> >Can anybody tell me,
> >how to find out the number of objects in a library?
> >TIA,
> >Murali
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) 
>mailing
>list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To 
>subscribe,
>unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>This e-mail is for the use of the intended recipient(s) only.  If 
>you have received this e-mail in error, please notify the sender 
>immediately and then delete it.  If you are not the intended 
>recipient, you must not use, disclose or distribute this e-mail 
>without the author's prior permission.  We have taken precautions 
>to minimize the risk of transmitting software viruses, but we 
>advise you to carry out your own virus checks on any attachment 
>to this message.  We cannot accept liability for any loss or 
>damage caused by software viruses.
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) 
>mailing list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>

___________________________________________________
Click below to experience Sooraj Barjatya's latest offering
'Main Prem Ki Diwani Hoon' starring Hrithik Roshan,
Abhishek Bachchan & Kareena Kapoor http://www.mpkdh.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


**********************************************************************
Coyle Hamilton Limited is regulated by the Irish Financial Services 
Regulatory Authority as an Authorised Advisor.  The Coyle Hamilton website 
address is 
http://www.coylehamilton.com
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager at info@xxxxxxxxxxxxxxxxxx

This footnote also confirms that this email message has been swept
for the presence of computer viruses.
**********************************************************************