iSeries Stored Procedure Help
bms at mscis.org
Thu Jan 25 13:19:47 MST 2007
> 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?
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?
More information about the PLUG