I tried this, no difference.
Have I angered the ADSM or SQL dieties?
Steven.
Leo Humar <lhumar AT VIC.BIGPOND.NET DOT AU> on 05/03/99 10:58:53 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: Steven Chaba/RG&E)
Subject: Re: Formatting of Query Outputs
G'day
If you send the output to a file it will be formatted on one line.
in NT the command would be "query stgpool > stgpool.txt"
Leo Humar
LCS Pty Ltd
lhumar AT vic.bigpond.net DOT au
-----Original Message-----
Fr
Fr
From: Steven Chaba <Steven_Chaba AT RGE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Date: Tuesday, May 04, 1999 12:41 AM
Subject: Formatting of Query Outputs
>(Runing server version 3.1.1.5 on AIX.)
>Here's a "pretty" question. When we do a "query stgpool", we get the
>following:
>
>ANS8000I Server command: 'query stgpool'
>
>Storage Device Estimated Pct Pct High
>Low Next
>Pool Name Class Name Capacity Util Migr Mig
>Mig Storage
> (MB) Pct
>Pct Pool
>----------- ---------- ---------- ----- ----- ----
>--- -----------
>ARCHIVEPOOL DISK 8,672.0 1.8 1.8 90
>70 ARCHIVETAP-
>EPOOL
>ARCHIVETAP- RGE 8,075,153. 0.2 0.5 90
>70
> EPOOL 9
>BACKUPPOOL DISK 43,360.0 62.7 62.7 90
>70 BACKUPTAPE-
>POOL
>BACKUPTAPE- RGE 6,044,151. 48.5 70.4 90
>70
> POOL 9
>COPYARCHIV- RGE 0.0 0.0
> EPOOL
>COPYBACKUP- RGE 7,750,533. 14.3
> POOL 0
>
>How do we get the various columns (especially the Estimated Capacity) to
>not wrap, but be displayed on a single line for better readibility? I
tried
>the "set sqldisplaymode wide" command, but it didn't seem to make any
>difference. This undesirable wrapping also is seen in the outputs of other
>commands.
>
>TIA
>Steven
>
>Steven Chaba
>ADSM Admin(-in-Training)
>Rochester Gas & Electric
>Rochester, NY USA
>716.771.2137v 771.724.8227f Steven_Chaba AT rge DOT com
|