ccBPM extract data from query input (muliple row) to multiline container.

[Former Member]

Hi XI Expert,

I have ccBPM scenario JDBC -

---

> RFC.

JDBC Sender contain multiple rows, how can i extract the muliple rows into multiline container so i can use for looping and send to RFC one by one.

Thank you and Best Regards

Fernand

[Former Member]

Hi Jai,

In order to use block foreach i need multiline container for input. how to prepared this multiline container from the single input with multiple row ?

Cheers

Fernand

[Former Member]

Fernand,

The output of the mapping in the transformation step is a multiline container. Use this multiline container in the block mode. Create a simple container again with the same MSg type (RFC) and use this container for Send step with in the Block mode.

Regards,

Jaishankar

[Former Member]

Hi Jai,

Actually, I need to process each row one by one, because later on i am not only calling RFC but doing others thing also.

JDBC -

---

> RFC -

---

> JDBC (Insert).

So the problem is how to convert sender data (multiple rows) to multiline container so i can loop and execute rfc and insert jdbc one by one.

Regards

Fernand

[Former Member]

>>because later on i am not only calling RFC but doing others thing also.

Ok. But still you dont need to convert multiple rows to multiple containers. Just do the mapping as I explained in my previous reply (with in a transformation step). You can use a blok step in par for each mode and with in that you can carry out the rest of JDBC operation.

Regards,

Jaishankar

[former_member859847]

Hi,

Your scenario is JDFC to RFC, where u have to extract the multiple records and apeend to RFC.

first thing, in order to bundle multiple rows

is there any time constraint ?(like with in 24 hours), in that situation use block step and append mode.

also use activate corelarion step in receive.

as u know, we need loop, recive, transformation out of loop send and block.

plese check the following blog related to BPM.

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2034. [original link is broken] [original link is broken] [original link is broken]

warm regards

mahesh.

[Former Member]

Fernand,

First you dont need BPM for this.

Just use ordinary select query that fetches multiple records from the db table.

Use a multimapping 1:N. ie. One JDBC source message generates multiple RFC calls. In mapping you need to change the Ocuurance of the target RFC message from 1..1 to 1..unbounded. You need to do this in the message tab of Message Mapping.

Regards,

Jaishankar