Re: SQL interactive session & activity history

On 1/8/07, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Session info is kept in internal space objects associated with a
particular
workstation display id.
You probably are signed into different or multiple workstations sessions
and
are getting history for that particular session.

Easiest way to get around this is probably to sign on to the session you
want, or delete unwanted histories (space objects) by entering
STRSQL->F3->2.  Option 2 deletes the space object.

To learn more about STRSQL exit options and session object search
algorithm
see:


http://www.centerfieldtechnology.com/publications/archive/February%2006.pdf

page 5, article STRSQL Conundrum.

Awesome article and I found my "lost" SQL activity history!  Yeah, a bit
mangled in the system dump, but nothing a little manual copying, pasting,
and editing won't cure.  Searching on "NAME-", I found two sessions.  What
is interesting is that the stuff I "lost" was in the section from a session
ID that I haven't used in several months!  No matter, I've got what I need,
and this particular problem is solved.

Elvis, in your article you mention a suggested workaround by using
Navigator, and saving the sessions in a PC file there.  It doesn't
automatically save the session (still requires action on the part of the
user), and that's what I appreciated about the STRSQL interface.  Oh well,
guess I'll just have to learn a new habit.

And thanks for the tip about using "CL: command" in the RunSqlScript!  And,
also the tip on the RunSqlScript executable.  Both nice timesavers!

- Dan