How can I check whether I'm connected to a database?

[gartsports]

Hi all!

I have an application where I CONNECT to a database if it's found on the system. Is there a way to check whether I'm connected prior to performing a DISCONNECT?

Thanks for the assistance!

Chris Proctor
Gart Sports
Denver

 

[ligang1000]

select count(*) into li_test from dual ;

Check sqlca.sqlcode , if it's not equal 0 , Means connection is wrong .

 

[gartsports]

I don't quite understand your answer.... I am connected to up to 4 databases at once. I have to be able to check each of them individually. Does your answer to my question handle this? If so, how?
Could you explain what "select count(*) into li_test from dual ;" does?

Thanks for your reply.

 

[ligang1000]

THen U must use 4 SQLCA , So you should check sqlcode for each one , because it's the only indicator . Best regards
LiGang
U get , U given ..