I have a issue in federated database.
I will explain the scenario
I have a table T1 in database called offlinedb. It has one column F1
I have an another table T2 in database uatdb.
I added attached table T1 in offlinedb using Federated Objects.
Then i created a procedure P1 in uatdb database with the following contents.
CREATE PROCEDURE P1
dynamic result sets 1
MODIFIES SQL DATA
for i as select f1 from t2
insert into t2 values ( i.f1 ) ; update administrator.t
set f1 = f1 - 1 ;
end for ;
If i execute the procedure P1, i am getting the following error. Error: DB2 SQL error: SQLCODE: -30090, SQLSTATE: 25000, SQLERRMC: 18
Please give some suggestions to rectify this issue. We need to incorporate this logic in our production server.