Re: SET Pause questions

set a main SQL that call all scripts

inside that SQL file you can do this

host pause "step 1"
_at_c:\folder\file1.sql
host pause "step 2"
_at_c:\folder\file2.sql
....
host pause "step N"
_at_c:\folder\fileN.sql

exit;

THat will solve your problems

Oscar

"SPN" <nollsp_at_excite.com> wrote in message news:f0479a7f.0205170447.31349b6c_at_posting.google.com...
> Hi all.
>
> I have a strange problem that I cannot seem to figure out.
>
> I have a DOS batch file that calls a sql file that lists quite a few
> sql files in order. Essentially, what I want is a pause and prompt
> between each execution.
>
> I have something like
>
> set pause on
> prompt 'doing step one'
> _at_c:\folder\file1.sql
>
> set pause on
> prompt 'doing step two'
> _at_c:\folder\file2.sql
>
> set pause on
> prompt 'doing step yada yada'
> _at_c:\folder\file3.sql
>
> The first prompt and pause is woking - but then it just cruises
> through the rest without stopping. In bed last night I thought about
> putting the set pause on in each of the individual files and not the
> main sql file that runs them.
>
> Any thoughts?
>
> -sn
Received on Fri May 17 2002 - 17:46:20 CEST