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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.