Re: ANSI mode and logging questions

Srini Raman (srini@anl.liv.usw.com) wrote: : In our system, we need to update two identical databases : , of which one acts as a backup. : I thought of this solution: : create two databases, one for each set and set the log : appropriately. But this creates the possibility of : opening and closing the datasbes frequently (since : you can't open two datasbes at the same time). You can use table from different database without closing and opening databases - use <database_name>.<table name> notation in Your queries to specify table in other database. There is a better solution. It's creation of alias for every table in database with log ... (see CREATE ALIAS). However, with Informix 5.0 I have had some troubles with such an aliases ( with databases on different hosts). : 2. What are the advantages and disadvantages (as far as : programming and performance is concerned) in creating : the databse in ANSI mode? The only advantage is more compatibility with ANSI. IMHO, direct indication with BEGIN WORK is more convinient. : Our Environment: Sol 2.3, Informix Online 5.0 With best regards, Vadim J. Nikitin