Re: HELP: Change user in .SQL script

You need to place semicolons at the end of each statement.

When you run it use the following syntax:

_at_junk.sql

Hope this helps

Mike Ressler

morgan.skinner_at_fisons-ls.com (Morgan Skinner) wrote:
>Hopefully this is a no brainer for someone out there. I have a .SQL
>script in which I want to do the following. Anyone got any
>suggestions...
>
>
>CONNECT usera/passworda
>
>... Do some SQL stuff
>
>CONNECT userb/passwordb
>
>... Do some more stuff
>
>
>The problem is that the machine halts after the first command ( I
>assume it is looking for a termination character or something like
>that). I have scripts that will do this from the command line, but I
>want to put all of this in one .SQL file.
>
>TIA.
>
>--------------------------------------------------------
>
>I was the Englishman in PM122 & PM123 with the Questions
>
>email : morgan.skinner_at_fisons-ls.com
>
Received on Wed Jun 21 1995 - 00:00:00 CEST