iSeries Stored Procedure Help

Brandon Stout bms at
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

More information about the PLUG mailing list