RE: [PHP] PHP + DB2

[Andrew Hill]

Rares,

Using ODBC should be fine; what problems are you having with input/output
parameters?
Also, what ODBC drivers are you using?

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers


 -Original Message-
 From: Rares Vasilescu [mailto:[EMAIL PROTECTED]]
 Sent: Monday, December 17, 2001 9:44 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP] PHP + DB2


 hi
 Anyone here used PHP to connect to a IBM DB2 database? Of course,
 using ODBC. I am having difficulties calling stored procedures
 with input/output parameters.

 Any help is appreciated.
 Rares




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] PHP + DB2

[Rares Vasilescu]

 Using ODBC should be fine; what problems are you having with input/output
 parameters?
I have a stored procedure like this:
CREATE PROCEDURE ADMINISTRATOR.Proc2 (IN idc INT,OUT max int) .
P1: BEGIN
SET max = 22;
END P1

And I try to call it like this:

$ps = CALL ADMINISTRATOR.PROC2(2,?);
$result = odbc_prepare($link,$ps);
$arrparam = array(1);
$rst = odbc_execute($result, $arrparam);
echo $arrparam[0];

and no luck.

 Also, what ODBC drivers are you using?
IBM DB2 ODBC DRIVER 7.01.00.40

I appreciate any suggestion.
Rares


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]