Splitting a message with multiple rows from the JDBC Adapter

[peter_jarsunek]

Hi,

I'd like to split the resultset message with multiple row elements and process each row separately..

Does someone have this experience?

Thanx, Peter

[Former Member · Accepted solution]

Hi Peter,

You will have to use a transformation step (N:1 mapping)to split the soure message into multiple single row messages.

After this you will have to use a Block with the mode "ParForEach" or "ForEach" to process each single row message in parallel or series respectively.

Let me know if you need any further info.

Rgds

R Chandrasekhar (RC)

[peter_jarsunek · Accepted solution]

Hi Chandrasekhar,

I tried to follow your advise, but I'm not able to complete the process correctly.

Let me explain my process:

First - output from the JDBC adapter goes into the first receive step. Of course, there are multiple ROW elements. (Should be marked the ingoing message marked in the container as Multiline??)

The next should be the transformation:

format of the source message is like

<message>

<row>

<column>w</column>

</row>

<row>

<column>w</column>

</row>

.

.

.

</message>

In the message I have the ROW element as 0..unbounded

and <column> element exactly 1

This message should be mapped to multiple messages of the format:

<message>

<value>w</value>

</message>

How should be the mapping be done?

Is it N:1 or 1:N (because in another thread there was an 1:N mapping advised)

Then (as you say) should follow the Block step:

Which message (container element) should be marked as Multiline? And what does it mean: Current Message?

Can you give me some advise, when and how to use the multiline mark?

Thanx a lot, Peter

[former_member185751]

Hi Peter,

Refer to my blog and see if it helps:

/people/sap.user72/blog/2005/03/15/using-xslt-mapping-in-a-ccbpm-scenario

Regards,

Sridhar

[Former Member]

Hi Peter.

You can have a look in the SAP BASIS component at the DemoAgency example: MultipleFlightBookingCoordination in the first transformation step does exactly what you wa nt.

Remember also that you can use multimapping (1:N or N:1) only within a BPM process.

HTH