Allen Thanks for the suggestion. The problem I've got is that the reports are the sort of ad-hoc SQL scripts that are run by administrators and operators from the admin client. While using '-comma' does reduce the column width, it is not appropriate in this scenario.
The fact that only the FILESPACE_NAME column is twice as wide as it should be makes me wonder if it's a bug? Regards Neil From: "Allen S. Rout" <a...@ufl.edu> To: ADSM: Dist Stor Manager <ADSM-L@vm.marist.edu> Cc: Neil Schofield <neil.schofi...@yorkshirewater.co.uk> Date: 17/04/2013 14:59 Subject: Re: [ADSM-L] SELECT statements and column widths On 04/16/2013 04:25 PM, Neil Schofield wrote: > I'm in the throes of an upgrade from TSM Server 5.5 to 6.3 and have had a > bit of a problem re-writing some of our custom SQL scripts. I was wondering > if anyone can point out what I'm doing wrong. > I don't know from "do wrong"; but the way I approached that was to dsmadmc -comma -dataonly=yes and do my formatting in my scripting engine. - Allen S. Rout ---------------------------------------- Spotted a leak? If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to http://www.yorkshirewater.com/leaks Get a free water saving pack Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water. http://www.yorkshirewater.com/savewater The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in England and Wales No 2366682
