RE: Session specific SQL

John,

The SQL session information for STRSQL is stored in an object on the System i itself. (you can search
the archives for more info on what object)

It'd be impossible for the statements to be mixed up.

The only thing I can think of would be if the development system was built or refreshed from a save of
the production system.

I suppose then you could be seeing statements that were originally run on production.

HTH,

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of John Arnold (MFS)
Sent: Thursday, July 31, 2008 10: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 e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.