Distributed query on databases with differents DB_LOCALE ...

Hi, Actually we can't not mix databases created with differents "DB_LOCALE" (error -23197) ... What's the best strategy/advice for working (e.g. : synchronize process, ...) with mixed databases because we want to create an UTF8 database for "web purpose" with "unicode support" but our other ERP database is ISO-819 ... T.I.A. Benjamin Garcia Vallejo Responsable Service Informatique IT Manager Z.I. Grasbësch L-3370 Leudelange #Informix

Benjamin: You will have to maintain separate connections to each database and perform any join operations in code space in your applications that need data from both or need to move data from one to the other. That's how dbcopy works so that it can copy data between databases with different locales or different logging modes. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

Hi Benjamin, if you just need to transfer data from one database to the other on the fly, you might consider using Loopback Replication (https://www.ibm.com/docs/en/informix-servers/12.10?topic=replication-loopback) with the code set conversion enabled in your replicates (https://www.ibm.com/docs/en/informix-servers/12.10?topic=replicate-enabling-code-set-conversion-between-replicates). HTH ------------------------------ -tz- TOMAS.ZAHRADNIK@DHL.COM ------------------------------