SHELL SCRIPT

harithay · Post by **harithay** » Sat Jan 08, 2005 1:00 pm

how do we write shell scripts for creating, dropping tables and scheduling jobs.

ray.wurlod · Post by **ray.wurlod** » Sat Jan 08, 2005 3:53 pm

You begin by posting the quesion in the appropriate Forum. Why would you expect the Editor to know this?

ketfos · Post by **ketfos** » Mon Jan 10, 2005 12:34 pm

Hi,
Use dsjob command in a shell script and invoke this command with relevant parameters from a Cron job (in Unix) or OS prompt.
Create a file in editor with SQL commands for DDL and invoke them using SQLPLUS (For ORacle only) enviornment (either at SQL prompt or a shell script).

Ketfos