Re: can you join ANSI & non-ANSI tables?

Yes, you can in 7(since you said tbconfig I'll asumme 5.x or lower)! "SYSMASTER" the SMI DB (GOD DB for Informix 6/7) is created as nonbuffered (best for FAULT tolerance) and ALL DBs MUST be able to communicate with it! Yet the key to your question was "JOIN", so I say if the join is not working try just reading the "ANSI" table in the non-buffered DB into a TEMP table (now you've got that "ANSI" table receated in the non-buffered DB) table and do the join with the TEMP table. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 7 Jun 1996, Kate Tomchik wrote: } Has anyone out there found a work around to joining tables where one is in } an ANSI logging Database and the other is in an Informix non-buffered } loggin database? } } If a join is not possible, has anyone coded a program between the two that } doesn't require closing all the open transactions in one database to get } information from another? } } Both databases are in the same tbconfig, but one is a vendor product and } one is the standard in-house developed database. We are trying to avoid } rewriting all the standard in house code and/or converting the standard } in house databases. } -- } L. Kate Tomchik (770) 433-8211 Ext: 86143 } ktomchik@homedepot.com 8^) } ----------------------->Have a mad phat day! } } } } }