Re: How do I use 2 DB at once?

Joel Schumacher wrote: > If I change it to the form " SELECT * FROM bbb@beta_engine_name:anytable", > it works just fine. > > I really dont want to have to use the form database@enginename:tablename. > enginename varies from site to site. I could store it someplace, but > that's one more thing (besides changine the global DBPATH variable) that > needs to be changed if the BBB database's location changes. > > So, is this a bug? Shouldn't Informix be able to locate my BBB database > from my DBPATH when I use the form database:tablename? No, this is not a bug. DBPATH is used to identify standard engine databases local to your machine. ONCONFIG I believe points to the local instance of ONLINE. (Hey what do I know its 1:00 am and I am still awake.) DBPATH will not be able to know about your other machines. Your solution is correct. Set up some globals, then in your statements, prepare them and execute them. (Dynamic Querries.) -Mikey BTW, bbb@machine:table is the documented method of queries so I guess it *cant* be a bug then, can it?