What is the API to call terminate

[Draw]

I have an application, where I do connect, handle a few requests, and
if for some reason, I lose connectivity, I detect that and loop(trying
to reconnect) until I regain connection to the DB. My problem is that
after I do a

EXEC SQL CONNECT.....<>;
and after I detect the problem with connectivity...I do this

EXEC SQL CONNECT RESET;
EXEC SQL TERMINATE;

The problem is, when I compile/link I get an error that says, that
"terminate" is an unrecognised token, anyone know what I can use
instead of 'EXEC SQL TERMINATE;' to get the same results I want?

Thanks, Draw

[Draw]

Draw wrote:

I have an application, where I do connect, handle a few requests, and
if for some reason, I lose connectivity, I detect that and loop(trying
to reconnect) until I regain connection to the DB. My problem is that
after I do a

EXEC SQL CONNECT.....<>;
and after I detect the problem with connectivity...I do this

EXEC SQL CONNECT RESET;
EXEC SQL TERMINATE;

The problem is, when I compile/link I get an error that says, that
"terminate" is an unrecognised token, anyone know what I can use
instead of 'EXEC SQL TERMINATE;' to get the same results I want?

Thanks, Draw

>>Just one more thing, I am using C++ for this development effort. In case that matters.

[Knut Stolze]

Draw wrote:

I have an application, where I do connect, handle a few requests, and
if for some reason, I lose connectivity, I detect that and loop(trying
to reconnect) until I regain connection to the DB. My problem is that
after I do a

EXEC SQL CONNECT.....<>;
and after I detect the problem with connectivity...I do this

EXEC SQL CONNECT RESET;
EXEC SQL TERMINATE;

The problem is, when I compile/link I get an error that says, that
"terminate" is an unrecognised token, anyone know what I can use
instead of 'EXEC SQL TERMINATE;' to get the same results I want?

CONNECT RESET is all you need. It disconnects from the database.

p.s: TERMINATE is a DB2 command and not a SQL statement.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany