Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
2015-10-04 17:10:43
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>
|
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, (continued)
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, PINNI, BALANAND (SBCSI)
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, Seay, Paul
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, MC Matt Cooper (2838)
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, MC Matt Cooper (2838)
- Re: Need Help Controlling Script Output, Field Lengths, Dennis Glover
- NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, 2838
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, Hunley , Ike [mailto:Ike.Hunley
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, 2838
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, Rejean Larivee/Quebec/IBM [mailto:rlarivee
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS,
Seay , Paul [mailto:seay_pd <=
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, ADSM : Dist Stor Manager [mailto:ADSM-L
- Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS, Ike Hunley [mailto:bizzorg
|
|
|