SQLExecDirect in CALL <stored_proc>

From: Date: Tue, 16 Jan 2001 00:55:00 +0000
Subject: SQLExecDirect in CALL <stored_proc>
Groups: php.db 
Request: Send a blank email to php-db+get-5891@lists.php.net to get a copy of this message
Hi This is probably a question for a core PHP developers working on ODBC.... I have compiled my php 4.0.4 against IBM DB2 libs and all is well untill i do something like odbc_exec($cid,"CALL <stored_procedure> ('arg1','arg2','arg3')"; Call fails saying it could not find certain library.....mentioning SQLExecDirect ODBC function.... However, the exact same SQL query works from within DB2 Command Center and CLP( Command Line Processor)...I went to investigate by reading "Developing Applications using CLI" (CLI = Call Level Interface) which is IBM's ODBC library and it says in clear text that SQLExecDirect function does support CALL SQL statement.....No examples though.....Only examples offered were ones where call was made by binding parameters using SQLBindParameter functions..... My questions are : 1. Does or Does not PHP 4.0.4 ODBC functions support CALL SQL statements with input/output arguments. 2. Can someone give me an example on how to accomplish a CALL statement with in/out args from PHP when calling a stored procedure.... 3. Are ODBC functions in PHP compliant with ODBC v3.5 specs? Much appreciated. Amir Mistric

« previous php.db (#5891) next »