Good info.
Does the session list get saved?
Can it be restored?
I was on a Webx with a 3rd party vendor, and my SQL session list accidently got cleared.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryan Dietz
Sent: Friday, January 20, 2017 4:46 PM
To: Midrange Systems Technical Discussion
Subject: Re: Interactive SQL session entries - where are they saved, can they be restored?
have a look in the JCRCMDS
http://www.jcrcmds.com/jcrdown2.html#JCRSSQL_tag
<snip>
JCRSSQL - Scan Interactive SQL sessions
Search through past STRSQL sessions! then displays a subfile of SQL statements that meet your selection criteria. You can also search through someone else's SQL sessions and look at those statements as well! The utility allows for execution of a selected sql statement.*
User ID *CURRENT____
It uses the output of a DMPSYSOBJ (Dump System Object) command.
Make sure you have authorization to the DMPSYSOBJ command on your system.
You can execute all UPDATE, INSERT, DELETE sql statements directly from this utility. * You would need to install Martin Rowe's EXCSQL utility to execute SELECT statements from the subfile.
David George contributed the code for the dmpsysobj command and the idea for allowing sql executions. Martin Rowe contributed the cool scan progress meter so you can see scan percentage completed and the EXCSQL interface. Thomas Raddatz contributed the sql execution program that uses SQL CLI direct DB2 interface coding. See the Links page to visit their AS/400 web sites.
</snip>
Bryan
Steinmetz, Paul wrote on 1/19/2017 3:47 PM:
Interactive SQL session entries - where are they saved, can they be restored?
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
