Re: Storing and Reusing Statements from STRSQL

The interactive SQL statements are also not saved through an upgrade, you
need to save them off to a source file to keep them.  The statements are
out there, I just can't remember the location, supportline database queue
knows that one.




Kirk Goins <kgoins@ix.netcom.com> on 04/11/99 02:24:33 PM

Please respond to MIDRANGE-L@midrange.com
                                                              
                                                              
                                                              
 To:      MidrangeList <midrange-l@midrange.com>              
                                                              
 cc:      (bcc: Danny Jahr/Lawson)                            
                                                              
                                                              
                                                              
 Subject: Storing and Reusing Statements from STRSQL          
                                                              








I'm in the middle of tracking down some SQL based permformance issues using
DBMON. I have some materials from a IBM DB performance class I took that
give me
some suggested SQLs to run over the data collected by DBMON. I really hate
to
keep re-typing or paging  back thru my previous cmds to get what I need.
Which
brings me to my question.

If I type a SQL from a STRSQL session how can I save it, and make it
runable
from a cmdline or cl?


--
Kirk Goins
Blue Heron Consulting,Inc
2418 SE Burnside Rd #321
Gresham, OR 97080
503-618-1493
EMAIL kgoins@ix.netcom.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---







+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---