• Subject: RE: Sql session save
  • From: "Walden Leverich" <walden@xxxxxxxxxxxxxxx>
  • Date: Wed, 27 May 1998 17:48:15 -0400
  • Importance: Normal

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

-Walden

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Dave Mahadevan
Sent: Tuesday, May 26, 1998 3:45 PM
To: RPG400-L@midrange.com
Subject: Re: Sql session save


Anthony Legros wrote:

> Hi folks,
>
> I'd like to start a small thread along the lines of - Is not extremely
annoying the way SQL sessions seem to be randomly saved according to
workstation id and user profile. Of cousre I know that they are not, but I
would like to know :-

I am told RUNSQLSTM will allow SELECT in the future (V4?)

>
>
> Are they saved in files ?

NO

> Where are they saved ?

System Objects

> Are they accessible ?

NO

> What naming rules are they saved under ?

Weird.  Once you call up STRSQL on a session without closing the previous
STRSQL session for the same user, the system creates a different naming
convention using the workstation ID and the user.  From then on, each
session is saved
separately.

> Thanks in anticipation of a deluge of helpful info.
>

One of the developers told me that the ability to manipulate SQL sessions
(statements copied from files, merging sessions etc.) is not on the list of
priorities and may never get done :-(There is a way to delete all the
sessions.  Then you
can become careful and not start multiple STRSQL.

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

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

Follow-Ups:
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.