MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2008

RE: Session specific SQL



fixed

SQL history is kept in some internal objects - they are viewable - I think there are some posts in the archives - Elvis knows!!

-------------- Original message --------------
From: Jerry Adams <Jerry@xxxxxxxxxxxxxxx>

John,

I have a very similar set-up; i.e., two i5's and, usually, 2 sessions
opened/started for each machine. I just checked STRSQL on both systems, and
they were, as far as I can tell, different as regards the history. It is a
little more difficult to tell for sure here since our second system
(backup/development) is pretty much a copy of the first (production) system.
The libraries that are different are never used for SQL (no data).

I don't know where the STRSQL history is kept, but I would bet that it is
somewhere on the i5, not the PC. The latter just wouldn't make sense. I went
to a dumb (5250) terminal, logged in with my profile, ran STRSQL and got the
same history that I have in my C/A session. When I use the WRKUSRJOB to find
out which files are open when STRSQL is running, all that I see in the list are
display (DSPF) files.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]
On Behalf Of John Arnold (MFS)
Sent: Thursday, July 31, 2008 9:42 AM
To: Midrange Systems Technical Discussion
Subject: Session specific SQL

Yesterday, I opened a fifth session of the 5250 emulator on my PC to run
some interactive SQL. We have two System i machines in house,
production and development. As I monitor and perform data analysis on
both system, I generally keep two sessions of each open (A & B -
Development, C&D - Production). For the fifth session (E), I randomly
open one or the other depending upon my need of the moment.

To make a long story short, looking through the history of SQL
statements in the fifth session, I noted that there was an interesting
mix of SQL statements from the two different systems. There are
libraries on production that do not exist on development and vice-versa
and there were clear examples of SQL statements accessing these
different libraries in the history.

Where is this information stored? Is it on the PC? How do I get data
from two separate systems in the same session? Inquiring minds want to
know?

John Arnold
(301) 354-2939


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact