iSeries Stored Procedure Help
teletautala at gmail.com
Thu Jan 25 13:34:56 MST 2007
we are using the native db2 database on the iSeries. If we use
'%term%' hardcoded in the query it works, but if we use a variable to
be used in stead of term it complains about the %.
On 1/25/07, Brandon Stout <bms at mscis.org> wrote:
> Daniel wrote:
> > We are using php on a linux box to call a stored procedure on an
> > iSeries v5r2 to get data. We have been unsuccessful in using LIKE in
> > the WHERE clause and using '%' as a wildcard when used in-line. What
> > should we use for wildcards?
> > -Daniel
> Do you have quote marks around the term, including the wildcard? Eg:
> SELECT * FROM t1 WHERE c1 LIKE "%term%";
> Also, what database are you using?
> Brandon Stout
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
More information about the PLUG