Joe - you can get shorter headers by selecting functions on the columns,
for example -
select left(volume_name,6) as volume, left(stgpool_name,10) as stgpool -
from volumes -
where stgpool_name = '9840APOOL' -
and status = 'FULL' -
and date(last_write_date) >= current date - 7 days
Which produces this in dsmadmc --
adsm> select left(volume_name,6) as volume, left(stgpool_name,10) as stgpool -
cont> from volumes -
cont> where stgpool_name = '9840APOOL' -
cont> and status = 'FULL' -
cont> and date(last_write_date) >= current date - 7 days
VOLUME STGPOOL
------ ----------
900002 9840APOOL
900002 9840APOOL
900067 9840APOOL
900176 9840APOOL
900444 9840APOOL
900584 9840APOOL
902090 9840APOOL
902281 9840APOOL
902385 9840APOOL
902387 9840APOOL
902453 9840APOOL
902460 9840APOOL
902465 9840APOOL
902469 9840APOOL
902478 9840APOOL
902500 9840APOOL
902511 9840APOOL
902522 9840APOOL
902543 9840APOOL
902545 9840APOOL
902549 9840APOOL
adsm>
Hope this helps,
--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <Pine.GSO.4.21.0112031013030.21494-100000 AT socrates.Berkeley DOT EDU>, on
12/03/01
In <Pine.GSO.4.21.0112031013030.21494-100000 AT socrates.Berkeley DOT EDU>, on
12/03/01
at 03:49 PM, Joe Faracchio <brother AT SOCRATES.BERKELEY DOT EDU> said:
>Interesting ... maybe even marvelous BUT ...
>Can you tell us how to SHRINK the headers??? In specifying " " for
>volume_name I still get the ----------------------------- underlines.
>Like:
> --STORAGE`_POOL_NAME---------
>------------------ -----------------------------
>200000 TAPEPOOL
>SIGH!
> ... joe.f.
>Joseph A Faracchio, Systems Programmer, UC Berkeley
>Private mail on any topic should be directed to :
> joef AT socrates.berkeley DOT edu
> (510)642-7638 (w) (209)483-JOEF (M)
> 5633
>On Mon, 3 Dec 2001, Poehlman, James wrote:
>> Within the select statement itself you can specify a header in place of the
>> default and make it the width desired.
>> IE: select
>> VOLUME_NAME,STGPOOL_NAME"--STORAGE`_POOL_NAME---------",LAST_WRITE_DATE"YYYY
>> -MM-DD_HH-MM-SS_-------" from volumes.
>> The parameter in quotes will be sent as the header, with that width.
>> Hope this helps.
>> Denny P.
|
