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------------------------------
Original Message:
Sent: Thu June 10, 2021 09:02 AM
From: Garcia Benjamin
Subject: 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