IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty


#Dataintegration
#Databases
#InfoSphereOptim
#Analyticstools
 View Only
  • 1.  restore one table

    Posted 11/30/20 04:26 AM
    Hi , 

    I have some archive files that includes 140 tables. I need to restore only one and same table for each archive file.
    I create a restore request and insert request for it but i couldn't find how to choose the table that i want to restore. 

    How is it possible to do it ? 

    Thank you , 


    ------------------------------
    Gunes INAL

    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: restore one table

    Posted 12/01/20 02:52 AM

    Hi Gunes,

    you should delete/blank out all the tables but the one you want to restore in the Insert-request.

    Regards,
    Fritz



    ------------------------------
    FRIEDRICH PFNEISL
    Optim SME
    Austria
    ------------------------------



  • 3.  RE: restore one table

    Posted 12/01/20 10:13 AM
    within your insert request you can edit the table map and eliminate all tables except the one that you wish to restore.

    ------------------------------
    Fred Booker
    ------------------------------