UDF for JDBC lookup in PI 71

[Former Member]

I am facing some issue while importing the SQL meta-data from db2 in PI 7.1 , guess the db2 version is old and not compatible with 7.1 or could be problem with drivers, I want to go head with writing UDF for the jdbc lookup, can you please let me know the code and how it can be written or blogs, thanks

[markangelo_dihiansan · Accepted solution]

Hello,

You can refer to this blog for lookups.

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

To implement just the jdbc lookup using dbaccessor just delete the RFCLookup method.

Hope this helps,

Mark

[baskar_gopalakrishnan2]

>>> can you please let me know the code and how it can be written or blogs, thanks

You can try this link if you dont want to use graphical jdbc lookup... Follow this link , it has code to use ...

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

Also refer these links

For 7.0 -  http://scn.sap.com/people/william.li/blog/2007/03/30/using-jdbc-connection-pool-in-xi-message-mappin...

For 7.1 http://scn.sap.com/people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-s...