Re: Loging and No Log Data Base

Question begin ------------------------------------------------------------------------------ Nils.Myklebust@ccmail.telemax.no writes Subject: Re: Loging and No Log Data Base Date: 15 Nov 1995 11:03:55 GMT I could of course do this if it where a 4GL program running on Unix using some C-functions to set up the pipe. The problem is we want to write MS Windows programs that are very user friendly (far beyond what is possible with any character based program) to select data, tell the user something about the data selected and then letthe user have an option to insert the customer number and some other data into a table. We also want to use standard programs available on the market that does this kind of thing. The only reasonable way of doing it I know is via a statement like: insert into tablex... select ... from ... where ... My wish is that tablex can be on a non logging database while tables in the from clause of the select statement is typically on a logging database, but may also be on the same non logging database as tablex. Remember the problem is that the select may return 100 thous --------------------------------------------------------------------------Quesito n end ANSWER: Suppose you want to do insert into tablex... select ... from tabley where ... tablex is in database X, and tabley is in database Y. You can create a synonym 'tabley' in the database X which links to the 'tabley' in the database Y, or vice verse (RTFM). To your Window program (or be it a character based program) , it only access one database ( X or Y). Better still, these two databases can be in two different instances and two different servers. Of course, they can have different logging mode. Zhou (Joe) Quan (England) @100561.465@compuserve.com Above opinions are my own.