<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=us-ascii"><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: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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@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'><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 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"'> Brian Stephens [mailto:bws001@gmail.com] <br><b>Sent:</b> Thursday, June 20, 2013 2:06 PM<br><b>To:</b> Greig Morrison<br><b>Subject:</b> Re: DB2 experts...<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>That wasn't my question for a couple reasons<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>OBDC is a PITA as you loose dictionary control.. Redefines are gone and the ability to change instance is as well..<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'>Essentially the client chose the solution stack and powerhouse on windows is making things less then convenient ODBC makes it near impossible when the data on the HP3000 is pretty much always redefined.. and it's better when we talk volume, (100+ databases 1100 tables, 3500 KSAM files and 2000 flat files) their dictionary is one of the largest I have ever seen over 300K lines of source code in the PDL..<o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Thu, Jun 20, 2013 at 1:39 PM, Greig Morrison <<a href="mailto:greig.morrison@sympatico.ca" target="_blank">greig.morrison@sympatico.ca</a>> wrote:<o:p></o:p></p><p class=MsoNormal>Add the customer table and associated database to your dictionary on Windows<br>and open using ODBC.<br><br>IBM DB2 ODBC DRIVER<br><a href="http://www.datadirect.com/products/odbc/db2/index.html" target="_blank">http://www.datadirect.com/products/odbc/db2/index.html</a><br><br>Greig<br><br>-----Original Message-----<br>From: powerh-l-bounces+greig.morrison=<a href="mailto:sympatico.ca@lists.sowder.com">sympatico.ca@lists.sowder.com</a><br>[mailto:<a href="mailto:powerh-l-bounces%2Bgreig.morrison">powerh-l-bounces+greig.morrison</a>=<a href="mailto:sympatico.ca@lists.sowder.com">sympatico.ca@lists.sowder.com</a>] On<br>Behalf Of <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Sent: Thursday, June 20, 2013 1:00 PM<br>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subject: powerh-l Digest, Vol 95, Issue 5<br><br>Send powerh-l mailing list submissions to<br> <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>or, via email, send a message with subject or body 'help' to<br> <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><br>You can reach the person managing the list at<br> <a href="mailto:powerh-l-owner@lists.sowder.com">powerh-l-owner@lists.sowder.com</a><br><br>When replying, please edit your Subject line so it is more specific than<br>"Re: Contents of powerh-l digest..."<br><br><br>Today's Topics:<br><br> 1. DB2 experts... (Brian Stephens)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Thu, 20 Jun 2013 08:42:42 -0400<br>From: Brian Stephens <<a href="mailto:bws001@gmail.com">bws001@gmail.com</a>><br>Subject: DB2 experts...<br>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Message-ID:<br> <<a href="mailto:CAPxvv-UfvXEAdpq_RDdvXcp-_ynbVA7_MMku4OkiYANcVsLwRw@mail.gmail.com">CAPxvv-UfvXEAdpq_RDdvXcp-_ynbVA7_MMku4OkiYANcVsLwRw@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Question;<br><br>Can DB2 (on windows) mirror or pass-though a table on iSeries, thus allowing<br>me to use a dictionary on Windows..<br><br>IE I have a customer table on the iSeries and I want to use a dictionary to<br>access it.. Can I create a customer table on windows define it in the<br>dictionary as a DB2 table and have DB2 on Windows get/put the data from/to<br>iSeries?<br><br>--<br>Thanks<br><br>Brian Stephens<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL:<br><<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20130620/e47dcf7d/attachment.html" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20130620/e47dcf7d/at<br>tachment.html</a>><br><br>------------------------------<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:<br><a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: &quot;subscribe&quot; in message body to<br><a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to<br><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" target="_blank">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:<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the list<br>archive at Google.<br><br>End of powerh-l Digest, Vol 95, Issue 5<br>***************************************<br><br>--<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" target="_blank">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:<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.<o:p></o:p></p></div><p class=MsoNormal><br><br clear=all><br>-- <br>Thanks<br><br>Brian Stephens <o:p></o:p></p></div></div></body></html>