Informix

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

    Posted Thu June 10, 2021 09:03 AM

    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


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

    IBM Champion
    Posted Thu June 10, 2021 09:20 AM
    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 Fri June 11, 2021 05:08 AM
    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
    ------------------------------