• Subject: Re: Sql session save
  • From: Dave Mahadevan <mahadevan@xxxxxxxx>
  • Date: Thu, 28 May 1998 12:32:39 -0400
  • Organization: Stoner and Associates

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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.