Multiple table insert using receiver jdbc adapter

[Former Member]

Hi,

I am trying o insert data in two tables using PI without using any stored procedure. I am trying to insert the data directly using the below mentioned structure.

SOURCE:

DT_ABC_SENDER

     -- IT_HEADER_TEXT

          --EBELN

          --LINENO

     --IT_ITEM_TEXT

          --EBELN

          --TDTEXT

RECEIVER:

DT_ABC_RECEIVER

     --InsertStatement

          --HEADER_TEXT

               action                    (insert)

               Table                    (Table 1)

               access

                    --IDS_ENQ_NO

                    --IDS_LINENO

          --ITEM_TEXT

               action                    (insert)

               Table                     (Table 2)

               access

                    --IDS_ENQ_NO

                    --IDS_LINENO

Using the above mentioned structure I am able to insert data in Table 1 but there is no data insertion done in table 2. Kindly help me urgently.

Regards,

Neeraj

[iaki_vila]

Hi Neeraj,

Please, dont open multiple threads with the same question:

Regards.

[Former Member]

Hello,

Use structure like this

DT_ABC_RECEIVER

    --InsertStatement1

          --HEADER_TEXT

               action                    (insert)

               Table                    (Table 1)

               access

                    --IDS_ENQ_NO

                    --IDS_LINENO

--InsertStatement2

          --ITEM_TEXT

               action                    (insert)

               Table                     (Table 2)

               access

                    --IDS_ENQ_NO

                    --IDS_LINENO

Thanks

Amit Srivastava