Re: [ADSM-L] Syntax for SQL "upper" in TSM 6.2

Hi John,

It is not David that asked , but me !

My problem is not to only look for some value in a field, but for some value as 
PART of the field, so something like :

Upper(%'$1'%)

And this does not work :-(

Cheers.

Arnaud


******************************************************************************
Corporate IT Systems & Datacenter Responsible
Panalpina Management Ltd., Basle, Switzerland,
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
******************************************************************************


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
John Stephens
Sent: jeudi 1 juillet 2010 14:31
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Syntax for SQL "upper" in TSM 6.2

David:
I am using select statements in 6.2 with the upper parameter with the following 
syntax

upper('$1')

Not clear on what you are needing but maybe this can help.


John Stephens
STORServer Consulting Engineer
www.storserver.com
Wk: 719-266-8777 ext 7201 
STORServer solves your data backup challenges.
Once and for all.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
David Bronder
Sent: Wednesday, June 30, 2010 6:32 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Syntax for SQL "upper" in TSM 6.2

PAC Brion Arnaud wrote:
>
> Like many others here, I'm fighting against the real DB2 world SQL
> syntax, and am totally unable to get a working equivalent of that query
> (simplified for demo purposes) :
>
> select * from summary where entity like upper(%'$1'%)
>
> Did anyone succeed in having such one working in  6.2 ?

I haven't moved to TSM 6.2 yet, but in 5.5 it needs to be upper('%$1%')
(the "%"s need to be inside the quotes)...

--
Hello World.                                    David Bronder - Systems Admin
Segmentation Fault                                     ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu