Re: SQL*PLUS ed on Win 95/Netware

We don't use SQL*Plus in the same environment you do (we don't use SQL*Plus in a client-server manner), but this is similar to what we experience and it's probably normal.

If we run a SQL statement that is already saved in a script file (like myscript.sql), it gets placed in the SQL buffer when we run it. When you type 'ed', it edits the copy in the buffer, not the original. When we edit it (in our case, it's with the UNIX Vi editor) and save it, it modifies the buffer, not the original, and the file is also called afiedt.buf. If we want the original to have the same changes in it, you have to explicitly save the buffered file and overwrite the original. Not sure how to do that in your environment, but for us, we would type: save myscript repl. (For 'myscript', the .sql extension is implied unless you explicitly specify an extension, and 'repl' means to overwrite the original 'myscript.sql' file.)

Not sure if this can be turned off, though. When editing, can you try something like 'ed myfile.sql' rather than just 'ed'? Maybe that might edit the original and not the buffer copy?

It can be annoying, but there are instances when you might not want to overwrite the original file and this way, SQL*Plus is playing it safe and waiting for the user to explicitly tell it what to do.

Oh, try also executing the command "clear buff" or "clear buffer". This might get rid of that DOS window that is your buffer? This is what we do to clear the buffer without exiting SQL*Plus. --
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Jason Selby <jselby_at_cams.co.uk> wrote in article <3572D654.63E6C649_at_cams.co.uk>...
> Hi
>
> I'm running ORACLE 7.1.4.3.4 client/server on Win95/Netware. I have a
> niggle which is that when I want to edit an sql command within SQL*PLUS
> the first time I type ED it envokes the notepad and I can edit my
> command no bother but after that a DOS box flashes up and it creates an
> Afiedt.buf file on my desktop. The only way round is to keep closing
> down SQL*Plus or cut and paste from a text editor without using ED at
> all.
>
> Anybody having the same problem ?
>
> TIA
>
> Jason
Received on Mon Jun 01 1998 - 13:50:29 CDT