Optim - Test Data Management and Archiving

 View Only
  • 1.  updating columns

    Posted 8 days ago
    Hi All, 

    Through Optim , How can I update columns in a table.
    I get the archive that I need , and I need to update some columns. What is the best practice for  running a query like this "update <table_name> set <Column_name> = 1234  where <Column2> = 999 "

    Best regards,

    CEO | Chief Data Engineer

  • 2.  RE: updating columns

    Posted 3 days ago
    Hi Gunes - the best way to accomplish this is by defining an "Archive Action" within Optim. Archive Actions are used for any special processing you might need in addition to what Optim provides. Refer to the Optim Common Elements document and please search for "Archive Action" when browsing the document:
    IBM InfoSphere Optim for DB2 for z/OS V11.3 PDF documentation

    The Archive Action allows you to execute an SQL among other things after the archive. I hope that Archive Actions would work for you.

     Baha Majid / IBM

    Baha Majid
    Executive IT Sepcailist
    Bethesda MD