cancel
Showing results for 
Search instead for 
Did you mean: 

dynamically fill primary key from a second table

Former Member
0 Kudos

Hi,

IDOC-JDBC

during runtime, the primary_key of the table must be filled dynamically.

something like,

it should go to a table dyn_key and get the hightest value of the field there and add one to it and pass it to dyn_key

any idea how do i do it?

regards,

nikhil.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

DB lookup could be suitable for such scenario. It would retrieve your key while building target msg (mapping) and use it to fill some fields dynamically

Chris

Former Member
0 Kudos

can you please post me few eg of how do I do this JDBC look up?

meanwhile I will also browse through

regards,

nikhil.

Former Member
0 Kudos

Hi,

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Regards,

Shabari

Former Member
0 Kudos

Hi,

check these

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

/people/francesco.bersani/blog/2007/03/05/data-lookup-optimized

Regards

Seshagiri

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Nikhil,

You can use JDBC look up for retrieving the current Primary key value.....

Regards

Ashwin M