Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Lookup UDF- To fetch multiple values


I have to fetch 3 values and populate it to the 3 fields in the target. The UDF am using is as attached. This UDF is for fetching one value. Kindly tell me about the changes I will have to make to fetch 3 values instead of 1 value.

String Query = " ";

Channel channel = null;

DataBaseAccessor accessor = null;

DataBaseResult resultSet = null;

// Query to retrieve the PROP value for the particular source value passed.

Query ="Select PROP from TANKS where ID='" + ID[0] + "' ";


//Determine a channel, as created in the Configuration

channel = LookupService.getChannel("<Business Service>","<Communication Channel>");

//Get a system accessor for the channel. As the call is being made to an DB, an DatabaseAccessor is obtained.

accessor = LookupService.getDataBaseAccessor(channel);

//Execute Query and get the values in resultset

resultSet = accessor.execute(Query);

for(Iterator rows = resultSet.getRows();rows.hasNext();){

Map rowMap = (Map);




catch(Exception ex){





if (accessor!=null) accessor.close();


catch(Exception e){



Edited by: SNIGDHA TRIVEDI on Oct 9, 2008 11:06 AM

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question