As far as I know it’s not possible to see the SQL commands that another user has executed. I guess that the system stores this data somewhere, but I’ve never seen any method of retrieving it.
i hope DSPJOBLOG may have the contentsabout these SQL statement.
Unfortunately, DSPJOBLOG does not contain anything about SQL commands from a STRSQL session. You may see informational messages like number of rows updated/deleted etc, but you will not see how this has been done.
Have the person use option 4 (4=Save session in source file ) when they exit SQL. You will be able to see and copy all commands.
You can’t force the users to take option 4 to save the session, but there must be a copy of the session stored somewhere, because when you start SQL your previous session is restored (if you exited with option 1 from your previous session). Does anybody know where this is stored?