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

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

Richard B Baird wrote:

Joe,

in a previous life (gosh it seems a long time ago) I would have used
STRSQL, but i'm contracting at a place that doesn't see the benefit of SQL,
and i'm in no position to tell them how to do thier jobs.

i use some QMQRY when I want to save something, but mostly I use EXCSQL
(somebody's freeware Brad Stone maybe? sorry whoever, I don't remember).
It doesn't archive it, but it's in my cmd history so if I want to save it
for later, i'll cust and paste it somewhere.

it's been a while, but does STRSQL allow you to delete bad commands? or
delete commands you don't want to 'remember' or do you have to edit the
session in SEU or some such to clean it up?

I ask, because sometimes, i'll type in a command 4 or 5 times before I get
the syntax right - especially because it uses a command interface, excsql
wraps your statements with quotes and doubles any that you use in your
statement, so it increases my chances of missing a quote here or there.

oh, how I wish I had the sql product......

have a great weekend everyone,

rick

---original message-------------------

From: Richard B Baird

i'd done it before a long time ago, but forgot how.  hopefully i'll
remember next time, and at least now it'll be in the archives.

I'm hoping you used STRSQL? to do this. If so, you could have saved the
session in a text file.  In fact, you probably still have the instructions
in the "magical STRSQL buffer", and if you did a STRSQL again, you'd see
those old instructions.

If that's the case, if'n I wuz you, I'd immediately do a STRSQL, then hit
F3
and on the "Exit Interactive SQL" session, select option 4 to "Save session
in source file".  You have options to create a brand new file and/or
member,
and then save the session.  Do this every time you do something new and
cool
or useful.

You'll eventually end up with a whole slew of snippets in there that you
can
then cut and paste when you need something.  They're also nice as a basis
for embedded SQL statements.

(See folks? I really DO use SQL! Honest!)

Joe

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.