Help needed

[woltor]

Hello,
I have a program that tries to connect to another database and then run another program so that it uses data from that database without databasename before each field I use..
In Character enviroment I disconnected this db and connected another db run the program, disconnected another db and connected back to this db, everything went fine,
but now I am trying to do the same tihing in GUI enviroment but my program doesnt complain anything about my connect statements but uses data only this db???
Is there some difference with connect statement in GUI and character enviroment?

 

[prog_user]

ALIAS KEYWORD

Hi -
From what i see, you are having a problem connecting to another DB in GUI... Try using this statement after the connect statement:

CREATE ALIAS DICTDB FOR DATABASE logical_dbname_of_newdb

and see how it works.