PHP alternative to mysql_data_seek for ODBC

[piyushjain220]

I am converting a PHP-mySQL application to a PHP-ODBC application. ie getting the database migrated from mysql to DB2.

1. While using mysql i used mysql_data_seek function so as to reset the recordset pointer, but this does not work for ODBC connection. I tried and checked odbc_fetch_row($recordset,0) for resetting the recordset, but this does not work. Does anyone know how to reset the recordset via ODBC connection?
------------------------------------------------------

2. odbc_num_rows function does not work properly for ODBC. Does not really give the correct result always. It provides -1 many times.
------------------------------------------------------

3. SQL_CUR_USE_ODBC is not supported by the ODBC-DB2 driver hence functions like odbc_ fetch_ row

[Barand]

 

To step through the result more than once, you can call odbc_fetch_row() with row_number 1, and then continue doing odbc_fetch_row() without row_number to review the result. If a driver doesn't support fetching rows by number, the row_number parameter is ignored.

[piyushjain220]

But in case odbc_fetch_row() function is not working, do we have an alternative?

Moreover how about if the cursor type (SQL_CUR_USE_ODBC) for odbc_connect is not supported?? do we have an alternative?

[Barand]

Don't know. You could check out the manual like I just did.

 

http://php.net/manual/en/book.uodbc.php

[piyushjain220]

I already checked the manual which didnt help. Anyhow thanks for your help.

[Barand]

I'm surprised, DB2 is in the list of databases that the library should support