Symptom
- ESP is being used to convert the following query as a Flex logic using getIterator() and setRange() functions:
select * from W_Employee_Win where empId = xxxxx and deptId in (10,20,30)
- The objective is to do multiple scans, using getIterator().
- The following CCL is implemented:
CREATE FLEX F_EMPLOYEE_DATA
IN I_EmployeeId_Input
OUT OUTPUT W_Employee_Win
SCHEMA Employee
PRIMARY KEY empId
BEGIN
ON I_EmployeeId_Input
{
W_Employee_Win_iterator = getIterator(W_Employee_Win_stream);
setRange(W_Employee_Win_iterator,empId,deptId,I_EmployeeId_Input.empId, .....)
- Is it possible to use setRange() so that the subsequent getnext call returns only those records where empid=xxx and deptid in (10,20,30) ?
Read more...
Environment
SAP Event Stream Processor (ESP) 5.1
Product
SAP Event Stream Processor 5.1
Keywords
typeof, streaming, processing , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.