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

hi all ,
the error has been fixed by adding a commit before insert into the federated table.

cheers