Re: ODBC_EXECUTE

Alejandro,

If you review the ODBC extension at PHP.net you will see there is no
support for out or in/out parameters.
http://php.net/manual/en/function.odbc-prepare.php

"If you need to call a stored procedure using INOUT or OUT parameters, the
recommended workaround is to use a native extension for your database (for
example, mssql <http://php.net/manual/en/ref.mssql.php> for MS SQL Server,
or oci8 <http://php.net/manual/en/ref.mssql.php> for Oracle)."

As the quote implies, the native DB2 extension would support this as
indicated here: http://php.net/manual/en/function.db2-bind-param.php .
However, this would require either native processing on IBM i or purchasing
the DB2_Connect software from IBM that would bring the full DRDA protocol
down to Ubuntu.


Regards,

Mike



On Thu, Dec 10, 2015 at 4:35 PM, Alejandro Olvera <alolvera@xxxxxxxxx>
wrote:

Does any one here know a work around or the PHP function to retrieve an
output
variable from a IBMi stored procedure.
I'm using Ubuntu UnixODBC and PHP5.

Here's an example of my php code.

$qry = "call storedproc(?,?,?,?,?,?);

If($stmt = odbc_prepare($conn, $qry));
$success = odbc_execute($stmt, array($i1, $i2, $i3, $i4, $i5, $o6));
//after this executed the $o6 string variable is empty.
if($success){
//I tried odbc_result and odbc_result_all and I'm still not getting

any

results

}

FYI my sixth parameter in IBMi stored procedure is set to INOUT and I can
see the value returned back when I debug the job.


Any ideas would be appreciated.

Thanks in advance
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.