User function message mapping

[Former Member]

Hi guys,

I would like to create a user function in message mapping, which return a field from a table in AS400 and gets 2 parameters to make the query...

If anybody knows it would be great,

thanks in advance,

Regards,

Muraii

[former_member189558 · Accepted solution]

Murai,

Are you using MQ series in between JMS Que and XI?

[Former Member · Accepted solution]

I'm using the JDBC adapter between XI and AS400, I'm newbie and I don't really know how to manage that , I'll try to do as Michal said but If you know another way....

Regards,

Murai

[Former Member · Accepted solution]

HI,

Any way you would have to use DB lookup

see thebelow links

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

SOAP Lookup - /people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function

Lookup - /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

Also read thru this to get more idea on lookups -

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

Lookup’s in XI made simpler - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

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

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

Lookups - /people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

Lookups - /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

Regards

Chilla

[Former Member · Accepted solution]

Thanks Chandra,

And in that case, how many communication channel do we need and what kind of channel?

Thanks again!

Regards,

Murai

[Former Member · Accepted solution]

Hi,

CCs for

-- Sender

-- receiver

-- DB Lookup with JDBC Adapter.

Agreements also same

Regards

Chilla.

[MichalKrawczyk]

Hi,

if you want to do a lookup to a DB

you can use this blog:

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

Regards,

michal