Informix

Expand all | Collapse all

Distributed query on databases with differents DB_LOCALE ...

  • 1.  Distributed query on databases with differents DB_LOCALE ...

    Posted 3 days ago

    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



  • 2.  RE: Distributed query on databases with differents DB_LOCALE ...

    Posted 3 days ago
    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
    ------------------------------



  • 3.  RE: Distributed query on databases with differents DB_LOCALE ...

    Posted 2 days ago
    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
    ------------------------------