JDBC Sender adapter - message split

[Former Member]

All,

Scenario:

Oracle Stage table - PI - ECC or R3, (depending on a particular value the record goes to ECC or R3 to post a transaction).

After the record is picked, flag is updated and depending on posting the transaction on SAP, the flag is updated in the stage table.

With the JDBC sender adapter, multiple records are picked up depending on the select statement in the sender comm channel.

I have the following rek.

Now the message is in the AE, before the message enters IE, I would like to split the messages

This would help me in resubmitting the failed (failed to post the transaction) records.

Is there any way that I would be able to do it?

Any guidence...

reg

[Former Member]

Hi Naveen,

An alternative way , instead of splitting the multiple record being picked up in a single poll, you can control the number of records being picked. By using the following statement in the sender cc

SELECT * FROM .... UPTO ROWS < 20

so that only 20 records are picked at a time. and resubmit the set of 20 in case it fails.

You can go for this method if it suits your requirement.

Regards,

Shamly

[stefan_grube]

This is not possible.

But you can split the message inside the IE. You can do this with a ccBPM.

Regards

Stefan