Re: [ADSM-L] SELECT statements and column widths
2013-04-17 13:14:42
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" <asr AT ufl DOT edu>
To:
ADSM: Dist Stor Manager <ADSM-L AT vm.marist DOT edu>
Cc:
Neil Schofield <neil.schofield AT YORKSHIREWATER.CO DOT 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
|
|
|