On Wed, 6 Feb 2013, at 12:42 PM, Michael Ryan <michaelrtr@xxxxxxxxx>
When I try and use it like this:(?
$SQLStmt = "SELECT * from cusmstp where NEWSYS.MSP_ValidateStoreFN(cast
as char (3) ) ) = '666'";
$prepare = db2_prepare($db2connection, $SQLStmt);
//db2_bind_param($prepare, 2, "$Wk_Error", DB2_PARAM_OUT);
db2_bind_param($prepare, 2, "$Wk_Store", DB2_PARAM_IN);
db2_bind_param($prepare, 1, "$Wk_Error", DB2_PARAM_OUT);
$stmt = db2_execute($prepare) or die("Failed SQL
Just noticed that you are binding two parms but I only see one "?" in the
SQL statement. Surely the return value will be in the result set - not a
parm? Haven't actually tried to do this myself but it just looks wrong.
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.