Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    1

    Unanswered: DB2 UDB Stored Procedure

    I was just wondering if you could help me out with this query -

    I have an instance created within which you have 3 databases say A , B and C.
    I have a Stored Procedure created in A say A.proc1.I have a requirement where I have to update some tables in B and C database.
    Is it possible to select or update any table from B or C database in this procedure where the procedure is been created in A database ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can update data in B or C or A, but not in more than one of the databases in the same UOW. Two phase commit support for Federation is coming in V9.

    BTW, if you are new to DB2, search for Federated Database in the documentation . This presentation might help

    http://www.gseukdb2.org.uk/downloads/0506federation.zip

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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