Skip to Content

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

JDBC Lookup UDF- To fetch multiple values

Hi,

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] + "' ";

try{

//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)rows.next();

result.addValue((String)rowMap.get("PROP"));

}

}

catch(Exception ex){

result.addValue(ex.getMessage());

}

finally{

try{

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

}

catch(Exception e){

result.addValue(e.getMessage());

}}

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

Former Member

Helpful Answer

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