#25112 [Opn->Bgs]: SQLExecDirect error with CLOB column in SQL

ID: 25112 Updated by: sniper@php.net Reported By: gms08701 at yahoo dot com -Status: Open +Status: Bogus Bug Type: ODBC related Operating System: windows 2000 sp4 PHP Version: 4CVS-2003-08-16 (stable) New Comment: http://dbforums.com/arch/39/2003/6/807113 Previous Comments: ------------------------------------------------------------------------ [2003-08-16 23:39:34] gms08701 at yahoo dot com Description: ------------ Using w2k sp4, mdac 2.8, ibm db2 8.1.3, windows native ODBC. Trying to do a select with a table join with a CLOB column in the select list, is not executing. If selecting a CLOB column without table joins executes correctly. The very same sql (with the table joins) works correctly via ibm db2's command line. You can get a bit more detail at http://dbforums.com/showthread.php?postid=3247451 Reproduce code: --------------- <?php $conn = odbc_connect ('IBM DB2', 'user', 'pass'); //$sql = "select options from NULLID.config where name = 'foo'"; $sql = "SELECT c.options FROM NULLID.config c, NULLID.modules m WHERE c.name = 'foo' AND c.name = m.name"; $result = odbc_exec( $conn, $sql ); odbc_result_all($result); ?> Expected result: ---------------- Warning: odbc_exec(): SQL error: [IBM][CLI Driver][DB2/NT] SQL0270N Function not supported (Reason code = "63"). SQLSTATE=42997 , SQL state 42997 in SQLExecDirect in C:\Inetpub\wwwroot\z.php on line 7 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=25112&edit=1