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

Multiple rows in a database

Hi all,

I am sending one single row from one data base to anotherdata base successfully. But I am not able to send multiple rows to another database.I am using parent and child relationship here.

Could anybody help me to solve this problem?

Thanks ,

Gopi.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jun 08, 2005 at 01:53 PM

    Hi,

    did you test your mapping?

    does you mapping (with multiple rows) work over there?

    Regards,

    michal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2005 at 01:54 PM

    Hi Gopi,

    When you are creating the Data Type for the source like

    <resultset>

    <row>

    <column name1>

    <column name2>

    .

    .

    .

    Make the occurance of the <b>row</b> as "0 to Unbounded".

    Hope this solves ur problem.

    Regards

    Sunita

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Michal Krawczyk

      Hi michal,

      In SXMB_MONI XML message, it is showing that it had accepted multiple rows from sorce and also send it to the destination (multiple rows).But Reciever Adapter is placing only one row in the destination table.

      Here is my target Structure :

      SalesOrderData_TDS occurence

      -Quote 1

      -row 0..unbounded

      action optional

      table 1

      -access 0..unbounded

      ....

      -key 0..unbounded

      -QuoteItems 1

      -row 0..unbounded

      action optional

      table 1

      -access 0..unbounded

      ....

      -key 0..unbounded

      Correct me i have wrong structure .

      Thanks ,

      Gopi.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2005 at 07:56 AM

    Hi Gopi,

    I think your target structure is wrong.

    It should be

    <SalesOrderData_TDS >

    <Quote 1>

    <dbTableName action=”UPDATE” | “UPDATE_INSERT”>

    <access>

    <col1>val1</col1>

    <col2>val2new</col2>

    </access>

    <key1>

    <col2>val2old</col2>

    <col4>val4</col4>

    </key1>

    <key2>

    <col2>val2old2</col2>

    </key2>

    The access element and key elemnet should be <b>"0 to unbounded"</b>

    This should solve your problem.

    Regards

    Sunita

    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.