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:
SQLCount = MAX_ITEMS;
EXEC SQL allocate DESCRIPTOR DES with max :SQLCount ;
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?????