Formatting of Query Outputs
1999-05-04 08:41:00
>(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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Formatting of Query Outputs, Steven Chaba
- Re: Formatting of Query Outputs, Leo Humar
- Re: Formatting of Query Outputs, Steven Chaba
- Re: Formatting of Query Outputs, Dwight Cook
- Re: Formatting of Query Outputs, Trevor Foley
- Re: Formatting of Query Outputs, Leo Humar
- Re: Formatting of Query Outputs, Trevor Foley
- Formatting of Query Outputs,
Steven Chaba <=
- Re: Formatting of Query Outputs, Richard C. Dempsey
- Re: Formatting of Query Outputs, Leo Humar
- Re: Formatting of Query Outputs, Dwight Cook [mailto:decook
|
|
|