[no subject]

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-----
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