gabrielsimon
Programmer
Hello.
I run 4gl programs in W2000 server with an Informix database running in a Solaris environment.
My question is, How can I change from one database enigne to another in the same 4gl program?
I need to make something like this:
DATABASE bdname@engine1_db
SELECT * FROM bdname@engine1_db:tablename INTO var
INSERT INTO bdname@engine2_db:tablename VALUES (var)
I try this an get an error: Server engine2_db is not listed as a dbserver name in sqlhosts
Well, I have the sqlhosts well setup in my Solaris, but, it looks like the 4gl interpreter search the sqlhost file in the Windows2000 server wich is running.
Any sugestion will be wellcome!
Thanks!
I run 4gl programs in W2000 server with an Informix database running in a Solaris environment.
My question is, How can I change from one database enigne to another in the same 4gl program?
I need to make something like this:
DATABASE bdname@engine1_db
SELECT * FROM bdname@engine1_db:tablename INTO var
INSERT INTO bdname@engine2_db:tablename VALUES (var)
I try this an get an error: Server engine2_db is not listed as a dbserver name in sqlhosts
Well, I have the sqlhosts well setup in my Solaris, but, it looks like the 4gl interpreter search the sqlhost file in the Windows2000 server wich is running.
Any sugestion will be wellcome!
Thanks!