Select working Database - Forum - OpenEdge RDBMS - Progress Community

Select working Database

 Forum

Select working Database

  • 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?

  • 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.

  • 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.