Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cursor remaining open after closing it

Status
Not open for further replies.
nshen

nshen

Programmer
May 14, 2002
53
US
Hi! I'm using DB2 v7.2 FP5 CLI client on the Windows 2000 and DB2 v7.2 FP4 Enterprise Edition Server on the AIX.
The ODBC DSN was created with CURSORHOLD disabled.

In my C code, after calling SQLFreeStmt with SQL_CLOSE to close the statement handle, the immediate re-use of the same handle would result in "SQL0502N The cursor specfied is an OPEN statemetn is already open. SQLSTATE=24502".

The code worked fine with all other ODBC sources except DB2.

Do I need to drop and re-allocate the statement handle?
Do I need to apply a patch?

Thank you!
regards, Nancy


 
Status
Not open for further replies.

Similar threads

THEROL
  • Locked
  • Question
Error: CLI0115E Invalid cursor state. SQLSTATE=24000 while querying programmatically
Replies
0
Views
266
THEROL
THEROL
johnherman
  • Locked
  • Question
Dynamic SQL within cursor DB2
Replies
0
Views
85
johnherman
johnherman
bibulous
  • Locked
  • Question
Concatenate multiple cursor results Into one row using SPUFI
Replies
0
Views
127
bibulous
bibulous
ebaccini
  • Locked
  • Question
DB2 7.2 ZOS col to row after query
Replies
0
Views
79
ebaccini
ebaccini
Spab23
  • Locked
  • Question
Program Gets DB2 SQL Error After 4600 Commits
Replies
3
Views
87
sathyarams
sathyarams

Part and Inventory Search

Sponsor

Back
Top