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
- 6.2
- 6.1.2

Back Next

SQL Responder Properties

When you create an SQL responder, you enter the name and the configuration details for the responder through the RulePoint user interface.

The following table describes the configuration properties of an SQL responder:

Property	Description
Name	Name of the responder. The responder name must be unique.
Description	Description of the responder. The description is optional.
Type	Select SQL Responder.
Connection	Select the connection name that you want to associate the responder to. You must create a JDBC connection before you create an SQL responder.
SQL	The SQL query for the responder. Use double angle brackets (chevrons) surrounded column names (<<column name>>) to identify the substitution parameters in the SQL statement. The data values provided in the response replaces the parameters with the matching parameter names.
Parameters	The parameters to use in the SQL query. Enter the parameters separated by comma. Parameters are a set of name-value pairs to substitute as values to the parameters in the SQL query. The field has values if the SQL query has parameters. Parameters are sent to the SQL query as an empty string for empty fields.
Marshaller Class Name	Class name of the marshaller.
Marshaller Properties	Key-value pairs to pass as properties of the marshaller.

Rename Saved Search

Table of Contents

User Guide

User Guide

SQL Responder Properties

SQL Responder Properties