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

Subject:	Re: [ADSM-L] Syntax for SQL "upper" in TSM 6.2
From:	David Bronder <david-bronder AT UIOWA DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Wed, 30 Jun 2010 17:31:37 -0500

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

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] Syntax for SQL "upper" in TSM 6.2, PAC Brion Arnaud Re: [ADSM-L] Syntax for SQL "upper" in TSM 6.2, David Bronder <=