Re: Storing and Reusing Statements from STRSQL

Kirk,

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

Probably the best idea is to press F13 (Services), then select option
4 to save the session in a source file.  From there you can parse it
into separate members to use with RUNSQLSTM or whatever.

But if you really want to know how there are stored internally, try:

DMPSYSOBJ OBJ(ISQLST<usrprf>*) CONTEXT( QRECOVERY)

The spaces are named ISQLST<usrprf><job><seq>

QRECOVERY also contains the work spaces for SEU and SDA among other
things.

HTH,
Doug
+---
| 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
+---