Optim - Test Data Management and Archiving

 View Only
  • 1.  Federation Server General Datatype Mapping

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


  • 2.  RE: Federation Server General Datatype Mapping

    Posted 11 days ago
    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 8 days ago
    Thank you ,

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