[DB2-L] Stored procedure/host variable/substring

Georg Peter

[DB2-L] Stored procedure/host variable/substring

Perry

please take a look at "The SQL Reference for Cross-Platform Development"





under



http://www-106.ibm.com/developerwor...0206sqlref.html < http://www-106.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sqlref.html >




This reference may answer your question(s).

Hope that helps !


With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
Vice Chair GSE Workinggroups DB2 Nord und Sued
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------
»"Next time you think you're perfect - try walk on water!"«

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Perry O'Connell
Gesendet: Montag, 27. November 2006 15:43
An: [login to unmask email]
Betreff: Re: [DB2-L] Stored procedure/host variable/substring



Thanks for you help Jackie and Agus

I did spot the reference in the SQL manual to the LIKE predicate,
in that you cannot use nested function in the predicate, but the original SQL works ok when run on a Windows DB2 environment.

Agus, your solution works fine, but Jackie I cant get yours to work, same problem :(

Is it unusal that SQL written in a Windows implementation of DB2 will not run on Z/Os?

Perry










[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

24/11/2006 15:25
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc
Subject
Re: [DB2-L] Stored procedure/host variable/substring








Have you tried adding additional parenthesis?:

foobar1 like concat ((substr(partkey,1,5)), '%' )
Jacquie
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



Abonnieren Sie den monatlichen Infobrief der Datenzentrale Baden-Württemberg und erfahren Sie regelmäßig die neuesten Nachrichten über aktuelle Projekte und Entwicklungen. Melden Sie sich an mit diesem Link http://www.datenzentrale.de/Info-Brief



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm