I *thought* I remembered a way to force the output of a query to be in the
display 80 column mode, or a "list" mode, but I can't find it for the life of
me.  I did tried some of the list suggestions and tried using the parameters
-QUIET, -DISPLAYMODE=LIST, and -OUTFILE.  Quiet and outfile had no discernable
effect, and displaymode=yes isn't a valid switch in dsmadmc batch mode.
effect, and displaymode=yes isn't a valid switch in dsmadmc batch mode.

I have been experimenting with passing the output to 'tail +10'  so that the
first 10 lines are omitted.  I am going to try using commadelimited, and use
TRanslate and CUT to see if I can get something that works for me.







Mark Adams <mark_adams AT CSGSYSTEMS DOT COM> on 03/02/2000 01:00:42 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>








 To:      ADSM-L AT VM.MARIST DOT EDU

 cc:      (bcc: Lisa Cabanas/SC/MODOT)



 Subject: Re: Reading of files generated by *sm and
          redirected to a text              file








Isn't it great how IBM decides that you somehow would like to see the output
differently in a file. :-(

The only way I have found to overcome this is by the following:

        dsmadmc -id=john -password=doe -commadelimited q n * f=d >
/path/filename

This will give you the output to a file in a comma delimited form. Then you
can
parse the information via a script or import it into a spread sheet, ...

Mark A. Adams
Systems Programmer
CSG SYSTEMS, INC.
(402) 963-8237


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Moneymaker, Bob
> Sent: Wednesday, March 01, 2000 11:52 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Reading of files generated by *sm and redirected to a text file
>
>
> *sm'ers.
> I'm having difficulty reading the garbage that is in the text file I
> generated in *sm (on a UNIX server) and redirected to an output file (also
> on a UNIX server). The command I used was:
>
> q n * f=d > [ABSOLUTE PATH AND FILE NAME]
>
> When I view the file, using vi, view, more, cat, or whatever, it does not
> have the same format as if I generated the output and read it from the
> screen in an ADSM session.
> Any hints, tips, or tricks would be greatly appreciated!
> Thanks in advance.
>
> Bob Moneymaker
> Sr. UNIX Administrator  voice:  1.916.351.4414
> SMSC Operations         fax:    1.916.351.4487
> at the California ISO           pager:  1.800.759.8888 PIN: 1466532
>                                 rmoneymaker AT caiso DOT com
> IBM Global Services
>