SAP Knowledge Base Article - Preview

2213236 - Using OR condition in setRange() function - SAP ESP 5.1

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.