PREV INDEX NEXT    SLUUG HOME

SQL in KSH
Running SQL Scripts in Kornshell

Why?



Easy to set up, easy to run, easy to modify, easy to clone


Can run SQL inline, SQL scripts, PL/SQL scripts


Insert shell variables directly or indirectly into SQL scripts


Security measures so folks don't catch your password


Use command substitution to insert SQL output into shell variables


Use background, nohup, cron to automate scripts


Setup scripts, logging, and bulletproofing



2002 April 10
Tom Chapin -- 314-721-3581 -- tjc@mvp.net