Oops! I omitted a whole sentence in my prior email. It should read:

***
Nevertheless, if TESTFILE is not in the *LIBL, it gives a SQL0204 error
indicating that TESTFILE can't be found for the "old" user (the one I use
for signing in to iNav initially), as if the CONNECT wasn't there...
***

My apologies,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Wed, Apr 27, 2011 at 9:02 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

Charles,

Interesting. I can run this without any apparent problems (V5R3):

DISCONNECT MY_SYSTEM;

CONNECT TO MY_SYSTEMUSER TESTUSER USING 'TESTUSER';
SELECT * FROM TESTFILE ;

Nevertheless, if TESTFILE is not in the *LIBL, it gives a SQL0204 error
indicating that TESTFILE can't be found for the "old" user (the one I use
for sigining in to iNav initially), as if the

I'm afraid that I'm out of ideas for this one. If I can get the time I'll
try to check it a little further.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Wed, Apr 27, 2011 at 8:32 AM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

Luis,

It doesn't appear possible to "DISCONNECT"...the discount/connect is
automatic when you select a system in the connection window.

The system list appears to come from iNav, and I've got my iNav
connection to the system set to logon with my windows user ID and
password.

I set up another connection to the system using a qualified name, and
configured it to prompt every time in iNav. All that appears to work,
but when I try to use it from Run SQL Scripts, I get the logon prompt
then an error message saying the connection was dropped.

Why I don't know...I know the profile is used by an application via
JDBC.....

Charles

On Wed, Apr 27, 2011 at 8:54 AM, Luis Rodriguez <luisro58@xxxxxxxxx>
wrote:
Charles,

AFAIK, short of signing in as a different user, the answer would be no.

What happens if you DISCONNECT and then CONNECT again as a new user?

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Wed, Apr 27, 2011 at 7:55 AM, Charles Wilt <charles.wilt@xxxxxxxxx
wrote:

All,

Is it not possible to change the user profile used by iNav's Run SQL
Script to connect with a different user profile?

Running iAccess 7.1, looked in the temporary JDBC connections....don't
see anything.

Thanks!
Charles
--
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.


--
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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].