iSeries Stored Procedure Help

Daniel 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 %.

-Daniel

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
> http://mscis.org
>
> /*
> 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 mailing list