<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Powerhouse works with our TurboIMAGE abstraction layer. What we do is pretend that the RDBMS database is Eloquence. That is we provide a replacement for the Eloquence shared library that talks to RDBMS’s. This allows for redefines, etc. in the dictionary. We have worked with DB2 on the AS/400, AIX, Linux and Windows. We can probably create something custom that will allow you to use your Powerhouse code as and it will not affect the AS/400 data or application. Let me know if you are interested. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Charles Finley<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>(619) 795-0720<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> powerh-l-bounces+cfinley=xformix.com@lists.sowder.com [mailto:powerh-l-bounces+cfinley=xformix.com@lists.sowder.com] <b>On Behalf Of </b>Brian Stephens<br><b>Sent:</b> Thursday, June 20, 2013 6:18 PM<br><b>To:</b> Conrad Whittall<br><b>Cc:</b> powerh-l@lists.sowder.com<br><b>Subject:</b> Re: DB2 experts...<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Thanks Conrad. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Db2 connect is ODBC. It's what we are using. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><br>Sent from my iPhone <o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><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:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span style='font-family:"Cambria","serif";color:#2F2F2F'>Brian,</span> <br><br><span style='font-family:"Cambria","serif";color:#2F2F2F'>I believe the DB2 feature you're looking for is called a table nickname...</span> <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"><span style='font-family:"Cambria","serif";color:#2F2F2F'>http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0002169.html</span></a> <br><br><span style='font-family:"Cambria","serif";color:#2F2F2F'>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?</span> <br><br><span style='font-family:"Cambria","serif";color:#2F2F2F'>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)...</span> <br><br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> DATABASE NAGI &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> TYPE DB2 &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> HIGH FILL HEX "7A" &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> NULL VALUES ALLOWED &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> DESCRIPTION &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> "NORTH AMERICAN GEOGRAPHICAL INFORMATION (DB2)" &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> OPEN "$DB2_LOCATION" &</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'>> USER "DBUSER" PASSWORD "DBPASS"</span> <br><br><span style='font-family:"Cambria","serif";color:#2F2F2F'>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).</span> <br><span style='font-family:"Cambria","serif";color:#2F2F2F'><br>Regards,<br>Conrad</span> <o:p></o:p></p></div></blockquote><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">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">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<o:p></o:p></p></div></blockquote></div></body></html>