Hi, I am trying to do a prepare statement with
an sql similar to "select * from tablea where col1=? and col2 = ?"
I then create an array with my parameter markers
ie.
array_parameter["col1"]= $column1
array_parameter["col2"]= $column2
then I use an
odbc_execute($preparestatement, $array_parameter)
I am using DB2 version 7.2 and the latest version of php on apache.
I have seen this done for update statements but not for select statements!
I am getting the following error
Warning: SQL error: [IBM][CLI Driver] CLI0005W Option value changed. SQLSTATE=01S02, SQL state 01S02 in SQLPrepare in C:/.....
I would like to use the prepare / execute statements as opposed to the exec statement for performance reasons.
Has anyone come across a similar problem?
Thank in advance for the help
