How to run sql files with pause

[zircon06]

I have shell script with bunch of sql file need to each with pause for each file. Each bascially idea in this way

@/u01/test/statement.sql

pause Press RETURN to continue...

@/u01/test/account.sql

pause Press RETURN to continue...

@/u01/testdetails.sql

Anyone guide me to run these in right way by giving pause for each sql file.

Thanks in advance

 

[RodKnowlton]

You can pause in most shells with:

echo "Press RETURN to continue..."
read junk

Here "junk" is just a variable to store the input in case you want to use it, and isn't necessary in most (maybe all) shells.

- Rod


IBM Certified Advanced Technical Expert pSeries and AIX 5L
CompTIA Linux+
CompTIA Security+

A Simple Code for Posting on the Web