Select working Database

Posted by MOS on 15-Jan-2007 07:30

Hi,

I' trying to change the working Database in a procedure.

I did not find function in 'Prodict.pl'. The Db is already connected.

How can I do that?

OpenEdge RDBMS - Forum

All Replies

Posted by Admin on 15-Jan-2007 08:29

Hi Marek,

This question really belongs in the language form, but I'll answer it here. Can you give a bit more detail about what you're trying to do?

The OpenEdge runtime can connect to a database at startup or at runtime (i.e. while running a .p). To connect to a database at runtime, look into using the "connect" statement and the "create alias" statements.

Posted by MOS on 15-Jan-2007 09:17

Hi,

I think that I found the solution.

I just need to write:

DELETE ALIAS "DICTDB".

CREATE ALIAS "DICTDB"

FOR database VALUE("db_name2") NO-ERROR.

and the new working DB becomes db_names2.

This thread is closed