Re: Sql session save

[Dave Mahadevan <mahadevan@xxxxxxxx>]

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