- 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
OUT OUTPUT W_Employee_Win
PRIMARY KEY empId
W_Employee_Win_iterator = getIterator(W_Employee_Win_stream);
- 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) ?
SAP Event Stream Processor (ESP) 5.1
typeof, streaming, processing , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.