RE: Sql session save

["Walden Leverich" <walden@xxxxxxxxxxxxxxx>]

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