InfoSphere Optim

 View Only

  • 1.  restore one table

    Posted Mon November 30, 2020 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 Tue December 01, 2020 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
    ------------------------------

    Original Message


  • 3.  RE: restore one table

    Posted Tue December 01, 2020 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
    ------------------------------

    Original Message