|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10469 ODBC_result() fails on DB2 LONG VARCHAR columns
Submitted: 2001-04-24 04:32 UTC Modified: 2002-05-17 00:00 UTC
Avg. Score:4.2 ± 0.8
Reproduced:4 of 4 (100.0%)
Same Version:1 (25.0%)
Same OS:1 (25.0%)
From: ltning at anduin dot net Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 4.0.4pl1 OS: Linux Slackware 7.1+
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
Solve the problem:
9 - 7 = ?
Subscribe to this entry?

 [2001-04-24 04:32 UTC] ltning at anduin dot net
Running on IBM DB2 UDB version 7.1 for Linux, PHP compiled with --with-ibm-db2 configure option.

Given the following table definition:
Connecting to the database:
  $conn=odbc_connect("TESTDB", "username", "password");
Inserting data:
  $rc=odbc_exec($conn, "INSERT INTO foo VALUES (1, 'This is some really long data..')");
And then running the following script:
  for($i=1;$i<3;$i++) {
      $rc=odbc_fetch_row($q, 0);
      $result=odbc_result($q, $i);
      echo "Data:".$result;
The first iteration returns the data from bar1 correctly.
The second iteration will give the following error on the line containing the ODBC_result() call:
Warning: SQL error: [IBM][CLI Driver] CLI0115E Invalid cursor state.
SQLSTATE=24000, SQL state 24000 in SQLGetData in /home/ltning/webmail2/functions/test.php on line 10

I have found that I do NOT get this error if I do not use the ODBC_fetch_row() function prior to the second iteration (moving that line out of the loop). My theory is that the DB2 engine handles ODBC_fetch_row() & ODBC_result() calls differently when LONG VARCHAR fields are involved than otherwise, and PHP does not know how to handle this.
I need to use the ODBC_fetch_row() on every iteration because I'm creating custom database functions, and there should be nothing directly "wrong" with that. I.e. this _should_ work..

If I can provide any other information, please tell me.. ;)

Best regards,
Eirik Overby


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2001-06-01 13:37 UTC]
depending upon the size and type of data you may need to try one of two things, or both.

in your php.ini there is a line "odbc.defaultlrl" which may need to be increased.  read the manual for more information on this.

also you may need to call odbc_longreadlen first, again read the manual for more information on this.

if either of these fixes the problem, great, if not ... as soon as I can get A) time, and B) DB2 installed on my linux box i'll check it out.
 [2001-06-02 05:02 UTC] ltning at anduin dot net
None of the two remedies you suggest make any difference. It's the odbc_longreadlen() I've been experimenting with too, but whatever I do it doesn't solve the problem, it just makes it more confusing ;)
Actually.. The string in the LONG VARCHAR column might be as long or as short as you want, the same result arises anyhow.

Btw, did you ever see the CHAR(x) FOR BIT DATA bug I've opened before? I was asked for feedback on it, and gave this, but nothing more happened... (It's used for the DB2 generation of unique keys...)

 [2001-06-08 15:51 UTC]
saw the other bug too.  i've seen it for awhile.  it falls under the 2 problems i currently have. :\
 [2001-06-08 16:14 UTC] ltning at anduin dot net
Heh.. Does that mean you recognize both as bugs, not user
errors? I'd be real pleased to hear that, since I've been
tearing out a considerable amount of hair over these two..

Hope you can figure it out asap, I'm currently working
around the problems in various not-so-pretty ways..

 [2001-06-12 10:28 UTC]
not recognizing anything as a bug yet, i haven't gotten db2 installed to try these out :P
 [2002-04-16 14:18 UTC]
is this bug still valid in the recent releases?  
 [2002-05-17 00:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2006-03-21 10:55 UTC] gaikwad dot sanjay at yahoo dot com
I also got similar issue when I tryed use odbc_fetch_row($rs, 0) on DB2 database.

if ($num_records < 0) {	// If odbc_num_rows returns -1 value then we can calculate the record count using  while loop.
		 while(odbc_fetch_row($rs)) {
		odbc_fetch_row($rs, 0); //This will point firsr record of the record set 

after executing this code when i try execute odbc_result($rs,1); it gives blank value where as value is present in database.It works fine with other databases.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 25 05:01:33 2024 UTC