Hi,
I would like to know the procedure of updating a sql server database table from CICS online transaction real time( when the user enters the data on CICS screen after filling all the fields on the screen when the user transmits the data should update the the db2 table on mainframe(standard practice) and also on the sql server database table).

Thanks.

VATTURI1

I think federated should be involved or federated replication could be used
update mainframe and replicate to target database keeping the sql server nickname or
update on mainframe table, connect to target table, keeping the nickname and update. 2phase commit is not supported for nicknames