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 24I 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]<?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);
?>[/PHP]
Thank you for all the help,
Jason
--------------------------
http://www.elefoo.com/
http://www.blackspyraldancer.com/