note 33924 added to function.odbc-primarykeys

[Devendra Joshi]

I want a list of primary keys of a table in db2

by using
'select * from SYSIBM.SYSKEYCOLUSE ' query i am getting the result on CLP
but when i am writing it in PHP as follows it returns 0 ROWS.

$mstmt="select * from SYSIBM.SYSKEYCOLUSE";
$b=odbc_exec($conn,$mstmt);
echo odbc_result_all($b);

where as if we write this code

$mstmt="select * from SYSIBM.SYSFUNCTIONS";
$b=odbc_exec($conn,$mstmt);
echo odbc_result_all($b);

it returns the correct data.
----
Manual Page -- [url]http://www.php.net/manual/en/function.odbc-primarykeys.php[/url]
Edit Note -- [url]http://master.php.net/manage/user-notes.php?action=edit+33924[/url]
Delete Note -- [url]http://master.php.net/manage/user-notes.php?action=delete+33924&report=yes[/url]
Reject Note -- [url]http://master.php.net/manage/user-notes.php?action=reject+33924&report=yes[/url]