Re: While we're on the subject, a more complicated SQL question.

Paul,

no excuses given, but I haven't visited ops nav in years.  I'd always been
a command-line kinda guy, and didn't see the need back then.

it's probably time I looked again - thanks for the tip

-----original message-----------
Richard,

You should have a look at the Run SQL Scripts (part of Database) in
Operations Navigator. This does not require the SQL product (i.e.
STRSQL), you can save your sessions and you can delete any of the bad
commands.

One other feature I like is that you can run multiple SQL statements in
one go and have all the result sets returned to you (e.g. 4 Select
statments and you get the 4 result sets returned - you can switch from
one to another on a single click)

I have a load of SQL scripts from the different sites where I work -
makes life much easier.

Only "problem" is that you can't promt your SQL commands - although I
think someone mentioned that you can with V5R2.

Paul