InfoSphere Optim

 View Only
  • 1.  Federation Server General Datatype Mapping

    Posted Sun January 09, 2022 03:48 PM
    Hi All , 

    I am using Federation Server to archive from mysql db. 
    I want to map "Text" data type to "Varchar" in all the system. 
    So is there any way to make that definition in  a single place and make it default ? 

    Best regards ,


    Gunes 
    +90 530 921 48 47

    ------------------------------
    GUNES INAL
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Federation Server General Datatype Mapping

    Posted Mon January 10, 2022 04:17 PM
    Hi Gunes,

    Have a look at the CREATE TYPE MAPPING statement, that should do the trick: https://www.ibm.com/docs/en/db2/11.5?topic=mappings-creating-data-type

    Regards,
    Marcel

    ------------------------------
    Marcel Berkhout
    ------------------------------



  • 3.  RE: Federation Server General Datatype Mapping

    Posted Fri January 14, 2022 06:02 AM
    Thank you ,

    ------------------------------
    GUNES INAL
    CEO | Chief Data Engineer
    TECHBROS
    +905309214847
    ------------------------------