Preface
RulePoint
RulePoint Concepts
- RulePoint Concepts Overview
- Understanding RulePoint Entities
Using RulePoint
RulePoint Objects
- RulePoint Objects Overview
- State of RulePoint Objects
Working with Topics
Working with Connections
Working with Sources
Working with Responders
Working with Responses
Working with Watchlists
Working with Analytics
- Analytics Overview
- Analytic Types
- Creating an Analytic
- Copying an Analytic
- Editing an Analytic
- Deleting an Analytic
- Viewing Related Objects
- Predefined Analytics
  - abs
  - average
  - ceil
  - charat
  - clean
  - compareto
  - concat
  - confidence
  - correlation
  - count
  - current
  - date
  - datedifference
  - endswith
  - even
  - floor
  - getcurrentdate
  - getdatefrommillis
  - getdateinmillis
  - geodistance
  - geoinbound
  - geoinsidearea
  - geointersect
  - geooutbound
  - geooutsidearea
  - geopassthru
  - indexof
  - integer
  - isblank
  - isholiday
  - isnum
  - istext
  - isweekday
  - isweekend
  - large
  - list2vars
  - lower
  - max
  - min
  - mod
  - mode
  - mround
  - odd
  - parse
  - past
  - percentile
  - power
  - proper
  - range
  - regex
  - replace
  - round
  - rounddown
  - roundup
  - sign
  - small
  - startswith
  - stdev
  - stringequals
  - stringindexof
  - stringlastindexof
  - stringlength
  - substring
  - sum
  - trim
  - truncate
  - upper
  - xpath
- Predefined Operators
  - contains
  - equalsSet
  - has
  - in
  - match
  - notMatch
  - search
  - unique
  - group by
  - distinct
  - unmatched
- Using the distinct, group by, and ummatched Filters
DRQL
Working with Rules
Working with Alerts
Setting Access Controls
Troubleshooting RulePoint Issues
Connecting to an Ultra Messaging Application
Creating an Ultra Messaging JMS Source

User Guide

6.1.2
- 6.2
- 6.1

Back Next

SQL Response Example

After you define an SQL Responder service, you can create a response that processes an SQL command.

You can run the response with its default values using the following syntax:

WHEN 1 stock WITH symbol="XYZ" THEN SQLStockResponse

In this DRQL,

SQLStockResponse

is the name of the response.

If you want to override all default parameters in your response within the rule text, you can specify the parameters or name value pairs for changes in individual parameters. The following rule provides the syntax for overriding all of the parameters for the SQL responder service:

WHEN 1 stock WITH symbol="XYZ" THEN SQLStockResponse WITH params="name=${stock.symbol},value=${stock.price}"

If you want to override a specific parameter in your response within your rule text, you can specify that parameter as a response property. The following rule provides the syntax for overriding a specific parameter value for this service:

WHEN 1 stock WITH symbol="XYZ" THEN SQLStockResponse WITH value="${stock.price}"

In another example, create the following SQL statement using name value pair:

INSERT into Stock (name, value) values(<<name>>,<<value>>)

You can use the following parameters to populate the SQL statement:

name =${stock.symbol}, value=${stock.price}

All undefined parameters are set to the value of empty string (which is NULL in Oracle). SQL statements must handle the format of the parameter value provided at the substitution point in the statement.

Using Brackets [] to Substitute IN Clause Parameters for an SQL Statement

The brackets around a comma-separated list is a formatting feature that you can use to update the IN clause of the parameters of a responder or response. You can use the feature to update the parameters by a comma-separated list in brackets, [XYZ, INFA, ABC].

Create an SQL responder.

UPDATE stock set processed_ind='A' WHERE name in <<names>>

Create and associate an SQL response with the responder.

updateresult

When the events

event1: symbol=XYZ

event2: symbol=INFA

, and

event3: symbol=ABC

come into the Stock table, the following rule triggers:

WHEN 3 stock s THEN updateresult  WITH names="[ ${s.symbol(*,COMMA)}]"

Using a Raw List to Substitute IN Clause Parameters for an SQL Statement

The raw list is a formatting feature that allows you to update the SQL Responder or the SQL Response. You can use the feature to update the parameters by a list of stock symbols.

Create an SQL responder.

UPDATE stock set processed_ind='A' WHERE name in <<names>>

Create and associate an SQL response with the responder.

updateresult

When the events

event1: symbol=XYZ

event2: symbol=INFA

, and

event3: symbol=ABC

come into the Stock table, the following rule triggers:

WHEN 3 stock s THEN updateresult  WITH names=" ${s.symbol(raw )}"

Using the rule below, when the following events come into stock1
: event1: symbol =IBM, event2: symbol=INFA, and event3: symbol=ABC, the rule fires.

For more information about other RulePoint formatting codes, such as NL and COLON, see Formatting_the_Output_of_your_Response
.

Rename Saved Search

Table of Contents

User Guide

User Guide

SQL Response Example

SQL Response Example

Using Brackets [] to Substitute IN Clause Parameters for an SQL Statement

Using a Raw List to Substitute IN Clause Parameters for an SQL Statement