ADSM-L

Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS

2015-10-04 17:10:43
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
To: ADSM-L AT VM.MARIST DOT EDU
That will help, but you can also do the AS "[ lots of spaces ]" to lengthen
the output field.  What we really need is a set displaymode=fixedraw.

This is an example of something that I do:

select stgpool_name as "Storage Pool Name         ",
cast(sum(est_capacity_MB*pct_utilized/100/1024) as decimal(7,3)) as "Total
GB in Pool", cast(avg(est_capacity_MB*pct_utilized/100/1024) as
decimal(7,3)) as "AVG GB / Tape", cast(count(volume_name) as decimal(4,0))
as "Tapes " from volumes where stgpool_name like 'CPY%' or stgpool_name like
'TAPE%' group by stgpool_name

Notice that he stgpool_name field is lenghtened to prevent the wrap by
adding the spaces.

<Prev in Thread] Current Thread [Next in Thread>