<div dir="ltr"><div><div><div><div><div><div><div>This is a legacy app that I'm not wanting to change..<br></div><div><br>I have a database say a product catalog that is used throughout the sister compnaies have identical databases.<br>
</div><br></div>I use the same programs But when the user is working on the different companies they need to hit the DB for the company they are working..<br><br></div>I need some mechanism to point to the different databases..<br>
<br><br></div>There are actually 2 problems<br></div><div>ACCESS PRODUCTS on the HP<br></div><div>becomes <br></div><div>ACCESS Schema.PRODUCTS in COMPANYA<br></div><div><br><br><br></div>I can select which OBDC driver is attached.. <br>
<br>> DATABASE COMPANY &<br>> Type ODBC &<br>> Open $COMPANY &<br>> UserID "********" &<br>> Password "********"<br><br></div>It works fine but <br>
</div>the ODBC or DB2 is adding the schema to the table name which takes away the uniqueness <br><br>show files<br>TEST2.CUSTOMER IN COMPANYA<br><br><div><div><br></div></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jun 11, 2013 at 10:52 AM, Bob Deskin <span dir="ltr"><<a href="mailto:Bob.Deskin@ca.ibm.com" target="_blank">Bob.Deskin@ca.ibm.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><font face="sans-serif">I may not understand this totally, but
if the individual databases can be identified on open/attach, you may be
able to use environment variables in the OPEN in PDL. If the instances
are accessed by different users, perhaps an OWNER technique would work.</font>
<br>
<br><font face="sans-serif">Bob</font>
<br>
<br>
<br>
<br><font color="#5f5f5f" face="sans-serif" size="1">From:
</font><font face="sans-serif" size="1">Brian Stephens <<a href="mailto:bws001@gmail.com" target="_blank">bws001@gmail.com</a>></font>
<br><font color="#5f5f5f" face="sans-serif" size="1">To:
</font><font face="sans-serif" size="1"><a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a>,
</font>
<br><font color="#5f5f5f" face="sans-serif" size="1">Date:
</font><font face="sans-serif" size="1">2013-06-11 10:22 AM</font>
<br><font color="#5f5f5f" face="sans-serif" size="1">Subject:
</font><font face="sans-serif" size="1">Relational databases/
OBDC connections...</font>
<br><font color="#5f5f5f" face="sans-serif" size="1">Sent by:
</font><font face="sans-serif" size="1">powerh-l-bounces+bob.deskin=<a href="mailto:ca.ibm.com@lists.sowder.com" target="_blank">ca.ibm.com@lists.sowder.com</a></font>
<br>
<hr noshade>
<br>
<br>
<br><font size="3">If you had multiple instances or the same database.. and
you wanted to control that access externally (because you only want to
have one copy of the program) </font>
<br><font size="3">How can you do it... (on the HP sonce the PDL controlled
the open a file equation it was easy) But on ODBC i'm trying to wrap
my head around how to make it work..<br>
<br>
</font>
<br><font size="3">Our platform is windows and the target database is DB2
on iSeries via ODBC..<br>
<br>
</font>
<br><font size="3">It doesn't appear I can insert a system variable in the
ACCESS statement</font>
<br>
<br><font size="3">It appears I can do this in the PDL.. so I may have some
rethink of the DB architecture unless someone else has some ideas..<br>
</font>
<br><font size="3">PS i'm just a bit fuzzy... taking a week to move and driving
2700 km can do that too you.. </font>
<br><span class="HOEnZb"><font color="#888888"><font size="3"><br>
</font>
<br><font size="3"><br>
-- <br>
Thanks<br>
<br>
Brian Stephens </font><tt><font>--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
<a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>
</font></tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank"><tt><font>http://lists.sowder.com/mailman/listinfo/powerh-l</font></tt></a><tt><font><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the
list archive at Google.</font></tt>
<br></font></span></blockquote></div><br><br clear="all"><br>-- <br>Thanks<br><br>Brian Stephens
</div>