jdbc lookup in UDF

[former_member186158]

According to SAP library

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/749daa12dd3676e10000000a114a6b/content.htm

I want to develop UDF using DataBaseAccessor, and the UDF has two output parameters like the SAP Standard JDBC Lookup. or I have use ccBPM?

because I have to use complex SQL query.

But I find out that, I can only have one output parameter in UDF,

I can not get Channel like the coding in Java mapping program,

I can't get channel with hard code, it have to transport to QAS, PRD system.

...

Channel channel = LooupService.getChannel("party","myService","myChannel");

....

Is it true?

Can I write lookup in UDF?

Thanks for your time.

[baskar_gopalakrishnan2]

Yes, You can write jdbc lookup in UDF. refer the below thread

http://scn.sap.com/thread/1875401

[rajasekhar_reddy14]

You dont need ccBPM.

refer below link

http://scn.sap.com/thread/3148752