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: [email protected] ****************************************************************************** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of John Stephens Sent: jeudi 1 juillet 2010 14:31 To: [email protected] 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:[email protected]] On Behalf Of David Bronder Sent: Wednesday, June 30, 2010 6:32 PM To: [email protected] 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. [email protected]
