JDBC Receiver: updates only header table how to update detail

[Former Member]

Hi

here the scenario idoc having one header and one details segments, header data goes to one sql table detail date to another sql table.

i created the sql structure in two ways one

table name

insert table

header table

action

access

detail table

action

access

2nd

table name

insert table

header table

action

access

detail table

action

access

in both ways one header table is updating detail table not. please help how to data will go in both tables

thanks

Message was edited by: sri rao

[Former Member · Accepted solution]

Hi,

could you pls try something like this..i was reading the documentation and thought of asking you to try this..

<root>

<HDR_StatementName>

<_hdrtablename action=”INSERT”>

<table>_hdrtablename</table>

<access>

<hfield1>val1</col1>

<hfield2>val2</col2>

....

</access>

</_hdrtablename>

</HDR_StatementName>

<ITM_StatementName>

<_itmtablename action=”INSERT”>

<table>_itmtablename</table>

<access>

<ifield1>val1</col1>

<ifield2>val2</col2>

....

</access>

</_itmtablename>

</ITM_StatementName>

</root>

Thanks & Regards,

Renjith

[Former Member · Accepted solution]

thanks renjith

it worked

sri

Message was edited by: sri rao

[Former Member · Accepted solution]

thanks Renjith

sri

Message was edited by: sri rao

Message was edited by: sri rao

[Former Member · Accepted solution]

Hi Renjith,

it is inserting only one line how to make it to inssert multiple lines

thanks

[Former Member · Accepted solution]

one <access> correspond to one record, so have multiple access tags created from the mapping to achieve this.

Thanks,

Renjith

[Former Member · Accepted solution]

Renjith,

can u tell how to do that?

sri

[Former Member · Accepted solution]

Hi Renjith,

I got it

thanks

sri

[Former Member]

hey Sri can you put the detail out here on how to do this detail peice. I am in a bind and I need some serious help with this.

Thanks

Ashish