DB2 experts...

[Greig Morrison]

From: Brian Stephens [mailto:bws001 at gmail.com] 
Sent: Thursday, June 20, 2013 2:06 PM
To: Greig Morrison
Subject: Re: DB2 experts...

 

That wasn't my question for a couple reasons

OBDC is a PITA as you loose dictionary control.. Redefines are gone and the
ability to change instance is as well..

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..

 

On Thu, Jun 20, 2013 at 1:39 PM, Greig Morrison
<greig.morrison at sympatico.ca> wrote:

Add the customer table and associated database to your dictionary on Windows
and open using ODBC.

IBM DB2 ODBC DRIVER
http://www.datadirect.com/products/odbc/db2/index.html

Greig

-----Original Message-----
From: powerh-l-bounces+greig.morrison=sympatico.ca at lists.sowder.com
[mailto:powerh-l-bounces+greig.morrison
<mailto:powerh-l-bounces%2Bgreig.morrison> =sympatico.ca at lists.sowder.com]
On
Behalf Of powerh-l-request at lists.sowder.com
Sent: Thursday, June 20, 2013 1:00 PM
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 95, Issue 5

Send powerh-l mailing list submissions to
        powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
        powerh-l-request at lists.sowder.com

You can reach the person managing the list at
        powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific than
"Re: Contents of powerh-l digest..."


Today's Topics:

   1. DB2 experts... (Brian Stephens)


----------------------------------------------------------------------

Message: 1
Date: Thu, 20 Jun 2013 08:42:42 -0400
From: Brian Stephens <bws001 at gmail.com>
Subject: DB2 experts...
To: powerh-l at lists.sowder.com
Message-ID:
        <CAPxvv-UfvXEAdpq_RDdvXcp-_ynbVA7_MMku4OkiYANcVsLwRw at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Question;

Can DB2 (on windows) mirror or pass-though a table on iSeries, thus allowing
me to use a dictionary on Windows..

IE I have a customer  table on the iSeries and I want to use a dictionary to
access it.. Can I create a  customer table on windows define it in the
dictionary as a DB2 table and have DB2 on Windows get/put the data from/to
iSeries?

--
Thanks

Brian Stephens
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.sowder.com/pipermail/powerh-l/attachments/20130620/e47dcf7d/at
<http://lists.sowder.com/pipermail/powerh-l/attachments/20130620/e47dcf7d/at
tachment.html> 
tachment.html>

------------------------------

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.

End of powerh-l Digest, Vol 95, Issue 5
***************************************

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.




-- 
Thanks

Brian Stephens 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20130620/bf3088da/attachment.htm>