× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



First, I don't think you can/should mix the i5* and db2* functions.

Second, your i5_prepare() function needs a db connection resource passed in as the first parameter /i5_prepare($db_connection, $qUpdateCustomer)/. You should have gotten that returned from your i5_connect() function. (I think it's i5_connect... I use the db2* functions)

Glenn

On 4/13/2010 7:41 AM, Tom Deskevich wrote:
Here is my code:

$statuscode='XX';
$qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_SEL( ? )";
$request = i5_prepare( $qUpdateCustomer );
i5_setparam( $request, 0, $statuscode );
i5_execute( $request );
$stuff=db2_fetch_array($request) ;
var_dump($stuff);

I got NULL NULL NULL on my var_dump

PROC_JC15_SEL shows on the DSPOBJD as not being run (ever).

Here is what the error log shows:
db2_prepare() expects parameter 1 to be resource, object given in
/www/zendcore/htdocs/xtld90083/jcs115.php on line 54
db2_bind_param() expects parameter 1 to be resource, null given in
/www/zendcore/htdocs/xtld90083/jcs115.php on line 5
db2_execute() expects parameter 1 to be resource, null given in
/www/zendcore/htdocs/xtld90083/jcs115.php on line 57
db2_fetch_array() expects parameter 1 to be resource, null given in
/www/zendcore/htdocs/xtld90083/jcs115.php on line

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of ADelgado@xxxxxxxxxxxxxxxxxx
Sent: Monday, April 12, 2010 4:54 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Calling a stored procedure from PHP,they can't
make this stuff any easier.

Does something like this not work for you?

e.g.

$qUpdateCustomer = "CALL SP_INSERT_F550101Z( ?, ?, ? )";
$request = i5_prepare( $qUpdateCustomer );
i5_setparam( $request, 0, $transactionId );
i5_setparam( $request, 1, 'C' );
i5_setparam( $request, 2, $_POST['ABALPH'] );
i5_execute( $request );

--
Alfredo Delgado / Web Development
6800 Broken Sound Pkwy, Suite 150
Boca Raton, Florida 33487







As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.