Skip to Content
avatar image
Former Member

Update 3tables in DB in SAP PI 7.3.1

Hi,

I have secanrio JDBC -->PROXY.I have 3tables at sender sice and based on DATE fld i need to update all 3tables.

Update date as per system date.Im using oracle11g.

I have tried using view but its not working in PI7.3.1

Kindly give an best solution for this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 07, 2013 at 04:52 AM

    Hi,

    if i understand you correctly after fetching the data from tables you need to update the 3 tables based on date.. if so use joins and update the same...

    else please elaborate your requirement...

    HTH

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      One solution could be to update one table after select query in sender jdbc adapter and then add another jdbc receiver along with proxy receiver to update remaining 2 tables.

      You may update the date in other tables using query by setting the values from first table where date was updated earlier. (action=SQL_DML)

      http://help.sap.com/erp2005_ehp_04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

      Also you may modify query in jdbc sender so that it checks date of all tables. (say date is blank in all 3 tables). This will ensure that newly added records are not selected again.

      You may consider run operating system command option also. But this will not provide transactional behaviour. If date field in not part of where clause while selecting records, you may update it using script. However this option can not be used if you want transactional behaviour that the records newly added should not be updated by current transaction.

      Regards,

      Beena.

  • avatar image
    Former Member
    Jan 07, 2013 at 01:13 PM

    Hello!

    In my opinion, the correct way of doing it is creating ON CASCADE (on update/on delete/on insert) triggers when changing the value of one table. This will create dependency that will propagate the value changed on the field of one table to the others, automatically using triggers.

    Please ask your DBA more information about this.

    BR,

    Lucas Santos

    Add comment
    10|10000 characters needed characters exceeded