iSeries Stored Procedure Help

Brandon Stout bms at mscis.org
Thu Jan 25 13:19:47 MST 2007


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



More information about the PLUG mailing list