RE: Disappearing SQL session

If you read through the posts in the following threads, I'm sure you'll get
the answer:

http://archive.midrange.com/midrange-l/200611/msg00394.html
http://archive.midrange.com/midrange-l/200801/msg00230.html
http://archive.midrange.com/midrange-l/200701/msg00490.html

HTH, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Disappearing SQL session

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