Re: single command out of dos prompt

From: Mike Dwyer <dwyermj_at_co>
Date: Wed, 4 Oct 2000 15:54:49 -0600
Message-ID: <ym%C5.20$9j1.6426@wdc-read-01.qwest.net>

(A little thanks to Oneil at 3:19)
plus33 -s logname/password_at_instance @sql_file_name

the sql file (don't use the .sql extension on the command line) contains a spool command and an exit command.

for example:
script.sql contains:
spool dual
select * from dual;
spool off
exit

run it with:
plus33 -s scott/tiger @script

type dual.lst

<hajir_at_my-deja.com> wrote in message news:8rdgr1$e09$1_at_nnrp1.deja.com...
> I need a single command out of dos prompt to:
>
> 1. Open SQL in same dos window
> 2. open a file
> 3. run the sql file
> 4. spool it out
>
> Thanks!
>
> hajir
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 04 2000 - 16:54:49 CDT