Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cursor is closed - calling function in a different sqx file

5 views
Skip to first unread message

Kdawg

unread,
Jan 21, 2012, 7:54:01 PM1/21/12
to

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?

Kdawg

unread,
Jan 24, 2012, 11:38:14 AM1/24/12
to

When returning from the function call, must activate db.
0 new messages