deleting tables using script

Bill Marcum · *nix forums Guru Joined: 28 Mar 2005 Posts: 1264

On 18 Jul 2006 22:47:51 -0700, manish
<manishmodgil@gmail.com> wrote:

manish · *nix forums addict Joined: 26 May 2005 Posts: 68

although i have got a turnaround solution for the problem..

running a sql file directly from the sql prompt...

but i would certainly appreciate if someone could tell me whether such
a kind of thing
is possible or not.

manish · *nix forums addict Joined: 26 May 2005 Posts: 68

The prompt

command>

is TimesTen release 6.0.2 prompt supportin the SQL statements.

I tried similar thing with the bash prompt and tcl/wish prompt. i.e
running
a script from the bash shell which makes use of tcl shell to execute
some
of the commands and i was expecting the same here but the things are
not
working.

manish · *nix forums addict Joined: 26 May 2005 Posts: 68

Hi All,

I have repeatedly delete a number of tables from the TimesTen database
that i am using on Solaris
platform.
To do so first i do

$ttdir ws;

where ws is the name of the DSN .It provides me with a new prompt

command >

On this prompt i write the command
command > delete from table_name1;
command > delete from table_name2;
command > delete from table_name3;
command > delete from table_name4;
....

to delete the table table_name*.

How could i write a scripts to do the job for me.

Thanks in advance.

Google