Folks,

  I have a PHP script that does:

 $statement = 'SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2';
 $result = odbc_prepare($dbconn, $statement);

  It succeeds, but always generates warning:

 PHP Warning:  odbc_prepare(): SQL error: [IBM][CLI Driver] CLI0005W  Option value changed. SQLSTATE=01S02, SQL state 01S02 in SQLPrepare in C:\temp\cli0005w.php on line 28

 Warning: odbc_prepare(): SQL error: [IBM][CLI Driver] CLI0005W  Option value changed. SQLSTATE=01S02, SQL state 01S02 in SQLPrepare in C:\temp\cli0005w.php on line 28

  I think I understand what the error means.  When I use the Microsoft ODBC driver it says:

 Warning: odbc_result() [function.odbc-result]: SQL error: [Microsoft][ODBC Cursor Library] Positioned request cannot be performed because result set was generated by a join condition, SQL state SL002 in SQLGetData in C:\My Server\gallery2\test-non-adodb.php on line 83

  So I presume the CLI0005W means CLI is invoking some extra hoops in order to execute the statement, for which I am grateful, but I don't want PHP to report it.

  I've tried modifying the error_reporting() in the PHP script, but can't seem to get rid of the warning.

  Is there any way to suppress (or prevent) these warnings at either level, DB2 or PHP?

  Thanks.