DB2 Error "No More Handles"

[Anon]

Hi all

I'm trying to use IBM DB2 as a database backend for a PHP application. I have to iterate through a big result set and apply a new SQL query to every result. This results in approximately 3000 queries.

After about 1300 queries, DB2 always reports the same error "No More Handles". Has somebody an idea?

I checked to see if I forgot some odbc_free_results, but this doesn't seem to be the problem as no statements are missing.

Any help would be appriciated...

Thanks in advance
reto

[mattr]

Sounds like you are doing something wrong. Can you provide the PHP and SQL code?