How to read a database's connection parameters

Posted by Admin on 18-Dec-2008 12:41

Hi!

I have to disconnect a BD, wait for some event, and then reconnect it.

There´s a way to read the connection parameters before the disconnect, so I can use them later, in the CONNECT statement?

Thanks!!!

Daniel

All Replies

Posted by Admin on 19-Dec-2008 02:43

You may want to check the DBPARAM function.

MESSAGE DBPARAM ("sports2000") VIEW-AS ALERT-BOX.

You should check the notes in the online help as there are some restrictions (like -P not being returned).

My preference would be to use some sort of configuration management (like in Dynamics), xml files or store all parameters in a .pf file per database.

Posted by Thomas Mercer-Hursh on 19-Dec-2008 11:34

Yes, I was going to suggest that, if you make your connection with a .pf in the first place, there is no need to read current parameters since you can just use the same .pf to reconnect.

This thread is closed