Hi Baha ,
I am trying run multiple update codes in one action ,example like below.
How can we put a delimiter for other codes like ";" in sql clients.
BTW I already try that set a delimiter for that.
update TABLE_ONE
set COLUMN_XX =99 ;
update TABLE_TWO
set COLUMN_YY =99 ;
update TABLE_TREE
set COLUMN_ZZ =99 ;
------------------------------
GUNES INAL
CEO | Chief Data Engineer
TECHBROS
+905309214847
------------------------------
Original Message:
Sent: Tue January 18, 2022 10:38 AM
From: Baha Majid
Subject: updating columns
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
IBM
Bethesda MD
4433065039
Original Message:
Sent: Fri January 14, 2022 06:15 AM
From: GUNES INAL
Subject: updating columns
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,
------------------------------
GUNES INAL
CEO | Chief Data Engineer
TECHBROS
+905309214847
------------------------------
#InfoSphereOptim
#Optim