Re: Gaining access to data outside

>It is my understanding that with Informix Online one can select, >update, delete, etc. information from a table which is not part >of the current database using the nomenclature >"remotedb:tablename" (assuming the remote database is actually >situated on the local site). > >It is also my understanding that Informix SE cannot perform the >same operation. > >Q1. Is this so ? > >Q2. Are there any work-arounds for SE using I-NET/STAR or some > other Informix product? > >Thanks in advance. >Nick Rumble. SE will allow you to access multiple databases from within a program. These databases must reside on the same host machine however. You simply include the 4GL lines (you ARE using 4GL aren't you?): CLOSE DATABASE dbase1 DATABASE dbase2 Note that you cannot use "LIKE" with a table from the second database. If your databases are on separate machines, you can always use the "workaround" (kludge) of "UNLOAD TO..."/"LOAD FROM..." and transfer the ascii files using kermit, tcp/ip, etc. (boo hiss). I'll leave more elegant solutions to users who are using Informix products which are newer than 1970. ------------------------------------------------------------------------------- "The expressed opinions are mine alone, and do not represent those of my employers. In the event of a mis-statement, the Secretary will disavow any knowledge of my existence." Todd Glidden "All Information wants to be free" - Cyberpunk Credo Computer Sciences Corporation Sacramento Army Depot