Issuing and stopping SQL queries
The following actions execute SQL queries. The actions expect a response and a handleResult action needs to be defined to handle each row returned.
action doSQLQuery(
string queryString,
action< dictionary< string, string > > handleResult )
action doSQLQueryOnError(
string queryString,
action< dictionary< string, string > > handleResult)
action doSQLQueryAck(
string queryString,
action < dictionary< string, string > > handleResult,
integer ackNum,
boolean onError )
The following query action allows you to specify a callback action for when the query completes. The parameters are (1) the query string, (2) the handler action for each row returned and (3) the handler for when the query completes. The handler for when the query completes has two parameters, an error string and an integer that specifies the number of rows returned by the query.
action doSQLQueryWithCallback(
string queryString,
action< dictionary< string, string > > handleResult,
action < string, integer> handleDone )
The following actions are similar to the above query actions except they return Apama events instead of results sets.
action doSQLEventQuery(
string queryString,
string eventType )
action doSQLEventQueryWithCallback(
string queryString,
string eventType,
action < string, integer> handleDone )
action doSQLEventQueryOnError(
string queryString,
string eventType )
action doSQLEventQueryAck(
string queryString,
string eventType,
integer ackNum,
boolean onError )
The following action cancels all outstanding queries in the queue.
action stopAll()
For more information on creating a
handleResult action, see
Handling query results for row data.
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.