REG: DB lookup

[Former Member]

Hi all,

I have a scenario where i need to make DB lookup and fetch values from DB table, But i am getting multiple rows from the table. Please can anyone suggest me how to handle multiple rows in DB lookup?

Thanks,

Siva

[prateek · Accepted solution]

JDBC lookup is generally used for some fields only. In ur case, u may use BPM with sync send step to receive complete payload, then u would be able to map the data easily using Transformation step.

Regards,

Prateek

[Former Member]

Hi,

you can go through below specified links . I guess it can help you out .

Lookups :-

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

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

Thanks

[Former Member]

Hi,

Proposed Solutions:

1) Import the data from the external system perform a value-based-transformation.

2) Execute a call to an external database with the purpose of accessing the desired data.

3) BPM can be used to perform Data Look Ups.

Refer these links

http://help.sap.com/saphelp_nw04/helpdata/en/c9/9844428e9cbe30e10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/frameset.htm

Regards,

Suryanarayana

[Former Member]

Hi Siva,

if you get multiple rows, the reason is your select statement!

You have to qualify the row(s) you request in your select-statement.

Regards Mario