SQL - Session saved statements

[G.Gaunt]

Just sign on as that user at that workstation and then exit SQL with option 4 to save session to a file? Otherwise this command will dump the session (substitute "uuuuuuuuuu" with the user name and "dddddddddd" with the display name):

 DMPSYSOBJ OBJ('ISQLSTuuuuuuuuuudddddddddd0000') CONTEXT(QRECOVERY) TYPE(19) SUBTYPE(EE)

For example if user name is GAUNT and display name is DSP38 then object name is:

 OBJ('ISQLSTGAUNT DSP38 0000')

[Guest.Visitor]

SQL - Session saved statements

Does anyone know where the file resides on the system where the SQL sessions are saved? For instance, when you exit interactive SQL you are asked if you wish to save your session. I need to review a user's SQL session statements. TIA Scott

[Guest.Visitor]

SQL - Session saved statements

I wish I could sign on as that user. What I am attempting to do is find out who changed millions of records within a file in one fail swoop. No one is admitting to it. It looks like the handywork of an SQL wizard. I am in hopes that whomever did this saved their session within SQL and is out there for me to find. Thanks, Scott