Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26

    Unanswered: error when update in federated table

    HI all,

    I have got table AA in my local database and got table BB in federated server.

    I have got a procedure which

    CREATES TEMP_AA and TEMP_BB tables.
    I am using TEMP_AA to load the upload data from TABLE AA, do some mapping to TEMP_BB and move the content of TEMP_BB to BB(FEDERATED).
    and drop the TEMP tables. BUT IA M getting the following error.
    SQL30090N Operation invalid for application execution environment. Reason code = 18.

    it is propblem with 2 phase commit.

    can anyone help me.

    cheers
    MELB

  2. #2
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26
    hi all ,
    the error has been fixed by adding a commit before insert into the federated table.

    cheers

Posting Permissions

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