Re: ODBC_EXECUTE

[Alejandro Olvera <alolvera@xxxxxxxxx>]

Thanks for your answer Mike.
On Dec 11, 2015 7:19 AM, "Mike Pavlak" <mike.p@xxxxxxxx> wrote:

> 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.