• Subject: Re: Sql session save
  • From: Dave Mahadevan <mahadevan@xxxxxxxx>
  • Date: Tue, 26 May 1998 15:44:47 -0400
  • Organization: Stoner and Associates

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


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.