I am looking for making a job which is have SQL statement executed. I have i5 system OS and database db2. I need some command statements and such options.
There is an easy way to execute SQL commands. You can use AIX shell script to make such commands in your db2 databases. Make sure you fix the runtime variables and schedule it to run the script. It is a very old method so I am not sure it is gonna work for the new OS you are using. But I know another way to do this. You can make a source member and run RUNSQLSTM to type sql statements.
I don't know about it but if the best thing to do pass the script into a stored procedure, may be there will be some command can not be stored inside procedure.