ADSM-L

Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS

2002-03-27 11:14:04
Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Wed, 27 Mar 2002 11:12:42 -0500
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.