dbTalk Databases Forums  

Cursor is closed - calling function in a different sqx file

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Cursor is closed - calling function in a different sqx file in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kdawg
 
Posts: n/a

Default Cursor is closed - calling function in a different sqx file - 01-21-2012 , 06:54 PM






We have a C++ program that I am updating. There are two sqx files
(one for each db that the app connects to). SQX A has a cursor that
works as expected until there is a reference to a function that
references sqx b. It returns a failure:

SQL0501N The cursor specified in a FETCH or CLOSE statement is not
open.

The cursor is declared "with hold". What is producing the failure?

Reply With Quote
  #2  
Old   
Kdawg
 
Posts: n/a

Default Re: Cursor is closed - calling function in a different sqx file - 01-24-2012 , 10:38 AM






When returning from the function call, must activate db.

On Jan 21, 7:54*pm, Kdawg <kevinwo... (AT) gmail (DOT) com> wrote:
Quote:
We have a C++ program that I am updating. *There are two sqx files
(one for each db that the app connects to). *SQX A has a cursor that
works as expected until there is a reference to a function that
references sqx b. *It returns a failure:

SQL0501N *The cursor specified in a FETCH or CLOSE statement is not
open.

The cursor is declared "with hold". *What is producing the failure?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.