Register Hereor login if you are already a member
If you put your SQL statements in a source member, then you can use RUNSQLSTM to execute the SQL command.
I create a QSQLSRC file and put the SQL commands in members in that file. You can put multiple SQL commands in a single member if you add a semi-colon ; at the end of the statement before the next statement.
Here is a sample source member:
UPDATE F$ACTCCOUT A SET MNGRID = (SELECT B.U$EMP# FROM U$DOMDIR B WHERE A.M$FIRST = B.U$FIRST AND A.M$LAST = B.U$LAST); UPDATE F$ACTCCOUT A SET M$EMAIL = (SELECT B.U$EMAIL FROM U$DOMDIR B WHERE A.MNGRID = B.U$EMP#);