RE: Remote DB2 SQL access, Library List

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Under what user profile are you creating the remote connection?  Do you have
communication entries for the system you are connecting from that specify a
default user?  Are you forcing a logon when you do your SQL connect?  If
not, you are probably running as QUSER on the remote system which probably
uses a different job description than your profile on box A or MYLIB on box
A is your Current library.  Prompt the SQL Connect and use your profile /
password for Box A from Box B and see if that makes a difference.


Christopher K. Bipes      mailto:Chris.Bipes@xxxxxxxxxxxxxxx
Operations & Network Mgr  mailto:Chris_Bipes@xxxxxxxxx
CrossCheck, Inc.          http://www.cross-check.com
6119 State Farm Drive     Phone: 707 586-0551 x 1102
Rohnert Park CA  94928    Fax: 707 586-1884

NOTICE--This e-mail may contain confidential and privileged material for the
sole use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.


-----Original Message-----
From: Urbanek, Marty [mailto:Marty_Urbanek@xxxxxxxxxxxx]

Assume my database resides on machine A in library MYLIB.

If I am signed on machine A, I can do a STRSQL and then issue a statement
such as:

select * from MYFILE
where DEF_NAME='SearchArg'
ORDER BY SOME_FIELD

The query works fine in that scenario, where I issue the query from the same
machine where the database resides. MYLIB is my CURLIB when I do the STRSQL.

However, if I am signed on machine B, do a STRSQL, SQL "connect" to machine
A (which is defined by RDBDIRE), and issue the same select statement, it
fails because it cannot find the table.

How can I get MYLIB into my library list, or do something so that it can
find the table without modifying the select syntax? I am aware that I can
modify the select to include the library or collection, such as "select *
from MYLIB/MYFILE", but the SQL is coming from another platform and it is
undesirable to have to change it.

Is there some other way I can help the query find the table in MYLIB when it
is issued remotely, perhaps by somehow setting the "default collection" or
controlling the library list of a server job on machine A? 

It seems like addind MYLIB to QSYSLIBL would work, but I would hate to do
something that pervasive.