I have written a multi-thread C++ ESQL application using dynamic SQL method 4(Descriptor) for handling select statements/method 1 for insert/delete/update/stored procedure. The model is one thread one connection, each with a unique connection name.
For handling insert/delete/update, no problem.
For handling select, it worked before. After i have changed a bit the source code(should not be related to SQL), after i have corruped a databaes device and fixed it and the then my program doesn't work properly now. When the server handles the select statement in the first time, it works, but not after. In other words, the connection only works for the first time for select!
My Code:
EXEC SQL allocate DESCRIPTOR DES with max QLCount ;
SQL Error:
Sqlcode: -33620275
Sqlerrmc: cs_objects: cslib user api layer: external error: ZZZZZ cs_objects: error performing requested operation.

I found the answer below from the internet and I have used purify to check my application and there was no error!

“For that particular error, since it's related to cs_objects, we may consider the possibility of an array overflow or a bad pointer in the application, which might have corrupted an Open Client object structure. As Anthony said, a debugger should help.”

I really have no idea, could anyone please give me some advice on this issue?????