inal Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of David
Bronder
Sent: jeudi 1 juillet 2010 20:54
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Re: Syntax for SQL "upper" in TSM 6.2
PAC Brion Arnaud wrote:
>
> My problem is not to only look for some
PAC Brion Arnaud wrote:
>
> 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 :-(
And as-written, it shouldn't work. Your full example used '%$1%' (with
the "%" inside the quotes),
@panalpina.com
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of John
Stephens
Sent: jeudi 1 juillet 2010 14:31
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Syntax for SQL "upper" in TSM 6.2
ata backup challenges.
Once and for all.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of David
Bronder
Sent: Wednesday, June 30, 2010 6:32 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Syntax for SQL "upper" in TSM 6.2
PAC Brion Ar
2 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.br...@panalpina.com
**************************
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf O
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
Hi gang,
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 ?
Th
