Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    25

    Exclamation Unanswered: how insert in table of federated database?

    how I can insert from a data base in a table that is in another data base (db2 v7.2).
    try to make it with Federated Database but it leaves the following error to me :
    SQL30090N Operation invalid for application execution environment. Reason code = "21". SQLSTATE=25000

    thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605

    Re: how insert in table of federated database?

    Hi,

    In db2 UDB v7.2 federated access has some limitations. With version db2 7.2 it is only possible to make selects from remote database.

    In db2 v8.1 UDB it is possible to make selects, inserts, updates, deletes to remote database.

    If you have remote database VSE/ESA then you also need to install fixpack 1 for db2 UDB v8.1.

    Hope this helps,
    Grofaty

    Originally posted by zarconja
    how I can insert from a data base in a table that is in another data base (db2 v7.2).
    try to make it with Federated Database but it leaves the following error to me :
    SQL30090N Operation invalid for application execution environment. Reason code = "21". SQLSTATE=25000

    thanks

Posting Permissions

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