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

ID: 25112 User updated by: gms08701 at yahoo dot com Reported By: gms08701 at yahoo dot com Status: Open Bug Type: ODBC related Operating System: windows 2000 sp4 PHP Version: 4CVS-2003-08-16 (stable) New Comment: Yeah, that wouldn't work ;) Im open to other suggestions that anyone may have. Thanks for listening... Previous Comments: ------------------------------------------------------------------------ [2003-08-17 01:05:14] sniper@php.net duh..disregard my previous comment, I didn't notice you're using windows.. :) ------------------------------------------------------------------------ [2003-08-17 01:04:41] sniper@php.net I was a bit too fast with the 'bogus' button. :) Anyway, I remember someone saying that even IBM themself suggest that you should actually use the UnixODBC instead of native DB2 driver..(have the library from http://www.unixodbc.org/ installed and configure with --with-unixODBC) Please try it out to see if it makes any difference. ------------------------------------------------------------------------ [2003-08-17 00:49:06] gms08701 at yahoo dot com I've been over that page already that you posted, but Im not sure how it applies. According to the code snippet I provided, if I comment out line 6 and uncomment line 5, I can then select the CLOB column via php. So even though the errors may be the same, the circumstances between this bug report and the page you provided aren't. Plus, the SQL works via DB2's command line, and not with php, so I don't think its a DB2 problem. So Im going to reopen it. If you still feel that its bogus, reset it as such, and Ill accept it as so. Thanks ------------------------------------------------------------------------ [2003-08-17 00:00:50] sniper@php.net http://dbforums.com/arch/39/2003/6/807113 ------------------------------------------------------------------------ [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