receiver JDBC structure after mapping .

[Former Member]

Hi ,

Here i am doing a scenario in which i need to pass multiple line items and header to the same table . i mean its a receiver JBC scenario. Here what i am trying is to create the receiver structure as

Structure

-

---

<n>Statement.<n>

-

---

<n>Table<n>

=----

---

Action

-

---

Table name

-

---

<n>Access

-

---

field 1

-

---

field 2

-

---

<n>Access

-

---

<n>Access

-

---

field 1

-

---

field 2

-

---

<n>Access

Like wise as per the number line items those number of access nodes will be created after the execution of my mapping program.

so please let me know your comments.

thanks & raegrds,

Ramana.

[Jitendra_Jeswan · Accepted solution]

You should create as many ACCESS as number of line items.

Just note that, if you are using INSERT as an action for all the line items. As soon as any Insert command failed the transaction is rollback. So in order to avoid this problem you can use UPDATE_INSERT instead.

Please reward points at the left side of the thread

[prateek]

Ur structure is correct using multiple access node. Go ahead with the scenarion configuration.

Regards,

Prateek