Re: Need to recover SQL session

I am not sure if you have multiple session objects in QRECOVERY.  If you do,
following might help:

If you're able to enter STRSQL on any of your workstation devices, hit F3
and select option 2 (Exit without saving session).  Keep doing this
entry/exit procedure until you delete all of your session objects (permanent
miscellaneous space objects in QRECOVERY).  When they're all gone you should
end up with a fresh STRSQL session that has no history in it, i.e. only
messages you see in the display are:

-----------------------------------------------------------------------
Type SQL statement, press Enter.                             
     Current connection is to relational database <YOUR_SYSTEM_NAME>.     
-----------------------------------------------------------------------

and you can't page up as there's no session history in that session.

Elvis

-----Original Message-----

How do I delete the session object? 



_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.