SELECT FROM DB2 with PHP - Invalid value specified for keyword "CONCURRENCY" in sta

Dev Shed Forums Sponsor:

AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!

August 15th, 2007, 05:21 PM

SimonJ621

Contributing User

Join Date: Jul 2006

Posts: 40

Time spent in forums: 12 h 50 m
Reputation Power: 2

SELECT FROM DB2 with PHP - Invalid value specified for keyword "CONCURRENCY" in sta

I am trying to select from a DB2 database with PHP. To my knowledge, the connection is being made, but the select statement won't run. The following is the error I receive:

Quote:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [IBM][CLI Driver][DB2/AIX64] SQL0644N Invalid value specified for keyword "CONCURRENCY" in statement "<ATTRIBUTE-STRING>". SQLSTATE=42615 , SQL state 42615 in SQLExecDirect in C:\wamp\www\db.php on line 24

I can't find much help online, which is why I am posting here. Any help would be much appreciated as I have never attempted to use DB2. Following is my PHP code:

PHP Code:


		
			
<?php 



function dbconnect($verbose) {

    $dbname = "**";

    $username = "**";

    $password = "**";

    

    $dbconn = odbc_pconnect($dbname, $username, $password);

    

    if (($verbose == TRUE) && ($dbconn == 0 )) {

        echo("connection to database failed.");

        $sqlerror = odbc_errormsg($dbconn);

        echo  "<br /><br />".$sqlerror."<br /><br />";

    }

    

    return($dbconn);

}





function display($dbconn) {

    $select_stmt = "SELECT * FROM blabla";



    if ($dbconn != 0) {

        $result = odbc_exec($dbconn, $select_stmt);

        if ($result == 0) {

            echo "SELECT statement failed.<br />";

            $sqlerror = odbc_errormsg($dbconn);

        }

        else {

            odbc_result_all($result);

        }

    }

}



$verbose = TRUE;

$dbconn = dbconnect($verbose);



display($dbconn);





?>

Thank you for all the help,

Jason
--------------------------
http://www.elefoo.com/
http://www.blackspyraldancer.com/

August 17th, 2007, 07:25 AM

SimonJ621

Contributing User

Join Date: Jul 2006

Posts: 40

Time spent in forums: 12 h 50 m
Reputation Power: 2

I used db2_connect instead of the odbc functions and it worked find. The following code worked:

PHP Code:


		
			
 $conn = db2_connect($dbname, $username, $password);



if ($conn) {

   $sql = "SELECT * FROM Table1";

   $stmt = db2_prepare($con, $sql);

   db2_execute($stmt);



   $rows = array();

   $i = 0;



   while (db2_fetch_row($stmt)) {

      $rows[$i] = db2_result($stmt, 0);

      echo $rows[$i]."<br />";

      $i++;

   }

}

else {

   echo "Connection failed. <br />";

   echo db2_conn_errormsg();

}

Thanks again.

Jason
------------------------------
http://www.elefoo.com/
http://www.blackspyraldancer.com/

August 20th, 2007, 03:59 AM

valined

Contributing User

Join Date: Oct 2004

Location: Brussels

Posts: 609

Time spent in forums: 1 Week 4 Days 17 h 17 m 28 sec
Reputation Power: 231

Quote:

Originally Posted by SimonJ621

What statement is at line 24 in db.php?

__________________
"Problem" is just a bleak word for challenge. -- Richard Fish
Javalanche

August 20th, 2007, 08:56 AM

SimonJ621

Contributing User

Join Date: Jul 2006

Posts: 40

Time spent in forums: 12 h 50 m
Reputation Power: 2

Hi Valined, I changed the script to be db2 specific (which worked better than the odbc connection functions) but I believe line 24 was:

PHP Code:


		
			
 $result = odbc_exec($dbconn, $select_stmt);

Jason
----------------------------------
http://www.elefoo.com/
http://www.blackspyraldancer.com/

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: