Professional Web Applications Themes

Create link to other ODBC databases within DB2? - IBM DB2

Can I create a link to an Oracle or Access database from within DB2? The reason I ask is because I need to create a trigger that will update a table in another database (Oracle or Access) when my DB2 table is updated. I'd like to do it from within DB2 rather that calling a seperate program. Any suggestions would be greatly appreciated. Thanks....

  1. #1

    Default Create link to other ODBC databases within DB2?

    Can I create a link to an Oracle or Access database from within DB2? The
    reason I ask is because I need to create a trigger that will update a table
    in another database (Oracle or Access) when my DB2 table is updated. I'd
    like to do it from within DB2 rather that calling a seperate program. Any
    suggestions would be greatly appreciated. Thanks.


    Jason Gyetko Guest

  2. #2

    Default Re: Create link to other ODBC databases within DB2?

    Jason Gyetko wrote:
    > Can I create a link to an Oracle or Access database from within DB2? The
    > reason I ask is because I need to create a trigger that will update a table
    > in another database (Oracle or Access) when my DB2 table is updated. I'd
    > like to do it from within DB2 rather that calling a seperate program. Any
    > suggestions would be greatly appreciated. Thanks.
    You can probably do this with DB2 Information Integrator (rather, I know
    you can use Oracle and SQL Server as a target, but I'm not sure about
    Access).




    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    [url]http://www.newsfeeds.com[/url] - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

  3. #3

    Default Re: Create link to other ODBC databases within DB2?

    Ian wrote:
    > Jason Gyetko wrote:
    >
    >> Can I create a link to an Oracle or Access database from within DB2? The
    >> reason I ask is because I need to create a trigger that will update a
    >> table
    >> in another database (Oracle or Access) when my DB2 table is updated. I'd
    >> like to do it from within DB2 rather that calling a seperate program.
    >> Any
    >> suggestions would be greatly appreciated. Thanks.
    >
    >
    > You can probably do this with DB2 Information Integrator (rather, I know
    > you can use Oracle and SQL Server as a target, but I'm not sure about
    > Access).
    >
    Hi,

    DB2 Information Integrator has an ODBC wrapper that can be used to talk
    to any ODBC driver, and it works with Access. You'd want to use the
    Oracle-specific NET8 wrapper to talk to Oracle.

    Yes, these wrappers will allow you to have an update trigger that
    changes data in Oracle/Access/both/other. Because the Oracle/Access
    tables would be mapped into DB2 as table names (actually, nicknames),
    you'd use the same SQL as if you were creating a trigger to update a DB2
    table.

    Hope this helps,

    Harold
    >
    >
    >
    > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    > [url]http://www.newsfeeds.com[/url] - The #1 Newsgroup Service in the World!
    > -----== Over 100,000 Newsgroups - 19 Different Servers! =-----

    Harold Lee Guest

Similar Threads

  1. Linux software to model and create databases
    By Francesco Moi in forum MySQL
    Replies: 0
    Last Post: June 27th, 11:20 AM
  2. Create ODBC connection
    By michaelmuller in forum Coldfusion Server Administration
    Replies: 6
    Last Post: July 1st, 01:14 PM
  3. create ODBC connection in CF?
    By michaelmuller in forum Macromedia ColdFusion
    Replies: 3
    Last Post: June 29th, 03:36 PM
  4. Create ODBC date
    By cf_scoob in forum Macromedia ColdFusion
    Replies: 3
    Last Post: February 22nd, 04:50 PM
  5. VB & Odbc link to Informix Database
    By Alan in forum Informix
    Replies: 0
    Last Post: July 13th, 06:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139