1) create a source member like this :
Member Type Text
DESCRIPTION SQL DO AN UPDATE
2) edit the member, and insert the SQL. you need a ; after each statement like this :
update lib/file set field=’stuff’ where field2=’stuff’;
update lib2/file2 set field3=’stuff where field4=’stuff’;
3) either schedule the CL command, or create a CL to run multiple SQL batches using the CL command :
RUNSQLSTM SRCFILE(LIB/FILE) SRCMBR(SQLMEMBER)
I believe you can also use RPG to run SQL statements, but, that’s a lot more complicated.
hope that helps, if you have any problems, let me know. RUNSQLSTM will create a spool file that contains results from the query runs.