Re: SQLExecDirect in CALL <stored_proc>

THANK YOU SO MUCH....... I rearly paid attention to it..... "Andreas Karajannis" <karajannis@mediaworx.com> wrote in message news:3A6458CE.9000700@mediaworx.com... > zambak wrote: > > > > Then I found a piece of information on DB2 CLI on Stored Procedure Call > > > > Syntax > > Between all it says : (quote) > > Unlike ODBC, DB2 CLI does not support literals as procedure arguments, > > parameter markers must be used.(end quote) > > I created a little app that users CLI and it would not work untill i used > > SQLBindParameter() function to connect procedure arguments to a CALL > > statement.... > > > > Basically You do "CALL SP_INS_MALL (?,?,?,?)" and then use > > SQLBindParameter() to replace ? with args..... > > > > Is there a way to call sp in PHP using current ODBC functions. Right now I > > don't need output parameters...only input???? > > > > Please see the docs for odbc_execute() > http://www.php.net/manual/en/function.odbc-execute.php > and odbc_prepare() > http://www.php.net/manual/en/function.odbc-prepare.php > on how to pass input parameters. > > > -Andreas > -- > Andreas Karajannis > mediaworx berlin AG > > Fon (0 30) 2 75 80 - 266 > Fax (0 30) 2 75 80 - 200 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >