Re: DBA*SQL question

In article <3s76et$sur_at_frame.frame.com>, tda_at_claus.corp.frame.com says...
>
>I just started using sqldba and I have noticed that unlike SQLPLUS,
>it is not possible to edit the current SQL command in that environment.
>In other words, if I type a long sql query in sqldba and I make a mistake,
>I have to retype the whole query again in order to correct the problem.
>My question: is there a way I can edit a query in sqldba without
>retyping the whole thing?
>
The answer is yes and maybe no. You didn't say what platform you are running on. SQLDBA does allow you to retrieve previous commands and edit them. I don't remember how because I cannot do it from my setup. I am accessing a V7.0.16 on HP-UX through an xwindow on my PC. I have never been able to get the key maping right so I lock up if I try to use some of the fuctions. It works fine from the HP console but I hardly ever use it.

I have just begun to use the new Server Manager which is replacing SQLDBA and has a Motif interface. This works great and allows you to point and click with the mouse too!

I am sure someone else will post the correct instructions for editing. I just wanted you to know how your setup effects your results. I would suggest that you use SQLPLUS instead of SQLDBA for your long queries. I only use SQLDBA for startup, shutdown, monitoring and only a few other commands. There are only a few things that SQLPLUS cannot do so use it whenever possible.

Good Luck, Received on Wed Jun 21 1995 - 00:00:00 CEST