Skip to Content
avatar image
Former Member

receiver JDBC structure after mapping .

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 12:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2008 at 12:15 PM

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

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded