Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Question Unanswered: updating the sql server database table from the cics transaction.

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    sql server

    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
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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