Skip to Content
author's profile photo Former Member
Former Member

Splitting a message with multiple rows from the JDBC Adapter

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2005 at 04:18 PM

    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)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2005 at 02:06 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 14, 2005 at 02:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.