note 33924 added to function.odbc-primarykeys
| From: | devendra_joshi at hotmail dot com | Date: | Fri, 11 Jul 2003 07:52:03 +0000 |
| Subject: | note 33924 added to function.odbc-primarykeys | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-51883@lists.php.net to get a copy of this message | ||
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 -- http://www.php.net/manual/en/function.odbc-primarykeys.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+33924
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+33924&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+33924&report=yes