Handling query results for row data
For query actions that return a result set of rows of data, your application needs to define actions to handle result sets. For example:
com.apama.database.DBUtil db;
action onload {
db.openQuickODBC("exampledb","thomas","thomas123",handleError);
db.doSQLQuery("SELECT * FROM NetworkInformation", handleNetworkInfo);
// ...
}
action handleNetworkInfo( dictionary< string, string > data ) {
log "Network: " + data[ "network" ] + " CountryCode: " +
data[ "countrycode" ] + " NIC: " +
data[ "networkidentificationcode" ] at INFO;
}