Need a .sh script for aix to run multiple DB2 queries

[lankaguy]

Hi,
I need to run a script in AIX to execute multiple DB2 queries and display the result on the screen.

on screen Outout like>

Time: output from DB2 sql1
--------------------------
Time: output from DB2 sql2
--------------------------
Time: output from DB2 sql3
--------------------------
sleeping 60 seconds...
=============== ===========
Time: output from DB2 sql1
--------------------------
Time: output from DB2 sql2
--------------------------
Time: output from DB2 sql3
--------------------------
sleeping 60 seconds...

Could you please help. many thanks

[Luuk]

Do you have the script (or commandline) to do one query?

If so, create a file that contains that line
do a chmod +x on that file to make it executable

run that script to see if that works

if it does, append more lines to that script....