Re: Disappearing SQL session

John,

I have found that the STRSQL sessions are loosely linked with the sessions.
The first 5250 session picks up one of the saved SQL sessions, the 2nd picks
up the next, and so on. To easily get what I needed from a saved session, I
have started as many as 4 5250 sessions before finding the STRSQL I needed.
I have taken to saving my sessions about every 2 weeks to a source member,
and then I can search. That option is part of the F13 set of options. Once
my session is saved to source, I then exit without saving the session in
order to clear the old stuff. If I need a statement from one of the source
member, I use copy-paste to get it back.

Jim

On Wed, Mar 19, 2008 at 12:20 PM, John Arnold (MFS) <
jarnold@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I performed several UPDATE SQL statements in a STRSQL session yesterday
on my development platform. The results were what I wanted so I decided
to copy the statements, create Query Manager SQL statements, promote
them to production and submit them.

BUT

When I opened my interactive SQL session this morning, it was empty. I
had several instances of the workstation open when I was doing this -
two of the three sessions still have historic queries but the one that I
want is missing. I am sure I did not exit without saving (I've made
that mistake before) but my session may have timed out before exited
cleanly.

My question is, does anyone know where the system i saves the
interactive SQL sessions and how one could retreive them?


John Arnold
(301) 354-2939

--
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.