Re: Sql session save

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Walden:

Here it is.  However, there are some caveats here.  You have to do the delete
on each session!

You can get the list of sessions from:
 DMPSYSOBJ ISQLENyouruserid* QRECOVERY 19 EE

My user profile name is CRP.  Output sample for me with one session:

 DMPSYSOBJ PARAMETERS
 OBJ- ISQLENCRP*                      CONTEXT- QRECOVERY
 TYPE- 19   SUBTYPE-EE
 OBJECT TYPE-           SPACE                                         *MSCSP
 NAME-     ISQLENCRP       QPADEV00790000  TYPE-  19   SUBTYPE-  EE
 LIBRARY-     QRECOVERY                       TYPE-  04   SUBTYPE-  01
 CREATION-    04/28/96  12:53:09              SIZE-     0000003400
 OWNER-       CRP                             TYPE-  08   SUBTYPE-  01

For multiples you will have multiple "NAME-" in the spooled output QPSRVDMP.
The "NAME-" is positionally in bytes:
      01-06  ::  ISQLEN
      07-16  ::  User profile starting the session.
      17-26  ::  Workstation device name for session selection
      27-30  ::  Session number for that workstation ID <0000 is first>

Sign on to the workstation ID for the one you wish to delete, then STRSQL,
then 2=Delete after F3=Exit.  HTH.


Walden Leverich wrote:

> Care to enlighten us as to the way to delete all the sessions?
>

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *