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;
}
Copyright © 2013
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.