<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Thanks Conrad. </div><div><br></div><div>Db2 connect is ODBC. It's what we are using. </div><div><br></div><div>There is a requirement to share the data with an AS400 which is running RPG. Many of the apps use both languages. The client selected the platforms and essentially the solution stack. We are trying to come up with adaptations. They use multiple instances of the same databases and point to them Db2 Obdc is making this complicated as its requiring the qualification of the schema in the <br>access statement. We were. Hoping to use different odbc connections as we we can assign a variable in the dictionary. But that doesn't appear to be a solution Then we get into refines. Anyone ever seen 4, 5 or 6 levels of redefine on an item. Types, sizes, whole and partial records. Not fun. We don't really want to rewrite their apps or normalize the database. So we are investigating all solutions. </div><div><br></div><div><br>Sent from my iPhone </div><div><br>On 2013-06-20, at 20:36, Conrad Whittall <<a href="mailto:Conrad.Whittall@ca.ibm.com">Conrad.Whittall@ca.ibm.com</a>> wrote:<br><br></div><blockquote type="cite"><div><font size="3" color="#2f2f2f" face="Cambria">Brian,</font>
<br>
<br><font size="3" color="#2f2f2f" face="Cambria">I believe the DB2 feature
you're looking for is called a table nickname...</font>
<br>
<br><a href="http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0002169.html"><font size="3" color="#2f2f2f" face="Cambria">http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0002169.html</font></a>
<br>
<br><font size="3" color="#2f2f2f" face="Cambria">However, this obviously requires
a local DB2 server instance and the federated database feature to be enabled.
Since you've already mentioned that you'd prefer not to use ODBC access,
I'm assuming that you're intending to use the native DB2 client access
built in to PowerHouse. If so, then why not just install and configure
the DB2 client (DB2 Connect?) on your Windows machine and then connect
directly to your DB2 for i tables?</font>
<br>
<br><font size="3" color="#2f2f2f" face="Cambria">Its been a while I since
I coded any PowerHouse apps, but in your PDL dictionary you would simply
declare the database TYPE as DB2 and the OPEN name as the name you defined
in your DB2 client configuration. Page 34 of the PowerHouse 8.4G PDL manual
contains the following example (using an environment variable for the open
name)...</font>
<br>
<br><font size="3" color="#2f2f2f" face="Cambria">> DATABASE NAGI &</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> TYPE DB2 &</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> HIGH FILL HEX "7A"
&</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> NULL VALUES ALLOWED
&</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> DESCRIPTION &</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> "NORTH AMERICAN
GEOGRAPHICAL INFORMATION (DB2)" &</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> OPEN "$DB2_LOCATION"
&</font>
<br><font size="3" color="#2f2f2f" face="Cambria">> USER "DBUSER"
PASSWORD "DBPASS"</font>
<br>
<br><font size="3" color="#2f2f2f" face="Cambria">Of course if you also have
tables in a local Windows-based DB2 instance that you then want to access
along with your DB2 for i table(s) then perhaps the table nickname route
is the way to go...so that all of your tables appear to PowerHouse to be
in one DB2 instance, and you'll be able to use cursors in PowerHouse to
have the database process queries and updates across both the local and
remote tables (rather than having PowerHouse access two separate databases
and perform the processing itself).</font>
<br><font size="3" color="#2f2f2f" face="Cambria"><br>
Regards,<br>
Conrad</font>
<br></div></blockquote><blockquote type="cite"><div><span>--</span><br><span>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</span><br><span>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a></span><br><span>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a></span><br><span>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a></span><br><span><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</a></span><br><span>This list is closed, thus to post to the list you must be a subscriber.</span><br><span>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</span></div></blockquote></body></html>