Mon Dec 06, 2021 6:24 am
Login Register Lost Password? Contact Us


Count of records shown in Result Section

Comments or questions specific to the features of ECL Watch

Wed Oct 30, 2013 9:40 am Change Time Zone

Hi,

Below is the sequence of lines on my ecl file. On my ECL IDE editor, I have set the Limit/count of returned rows to be shown on ECL watch as 100.
1. STEP1: Create a Record set of a DataSet,which contains 40844 rows and OUTPUT
FloridaPersons :=(Tutorial.File_OriginalPerson(Tutorial.File_OriginalPerson.state = 'FL'));
OUTPUT(FloridaPersons,NAMED('FloridaPersons'));
2. STEP2: Create an Indexed recordset as below and OUTPUT that:
AllFloridaPersonsExceptFirst:= FloridaPersons[2..] ; //all recs except the first
OUTPUT(AllFloridaPersonsExceptFirst,NAMED('AllFloridaPersonsExceptFirst'));

On execution, ECL watch "Result Section" displayed count as 100 rows for STEP1 result, whereas 40843 for STEP2 result.

My expectation was count of rows will be displayed as 100 for both STEP1 and STEP2 because the Limit of rows has been set as 100 on my ECL IDE.

Is this difference an expected behavior? i.e., result of Indexed RecordSet/DataSet will display the total count of returned records irrespective of Limit set on ECL IDE.

Regards,
Rajesh
Attachments
ECL Watch.jpg
ECL Watch
(47.68 KiB) Downloaded 1228 times
rajesh.dorairaj
 
Posts: 9
Joined: Wed Oct 30, 2013 9:22 am

Wed Oct 30, 2013 1:27 pm Change Time Zone

Hi Rajesh,

The short answer is that "Yes", this is expected behavior, because you requested an indexed recordset result, so the compiler wanted to accommodate you and overwrite the 100 record limit and stream to you all of the records that you requested. A filtered request like the example in Step 1 will use the 100 record limit that was set.

Also, you may notice that any OUTPUT to a logical file (third parameter of OUTPUT) will also stream all of the results of the logical file.

Hope this helps!

Bob
bforeman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1005
Joined: Wed Jun 29, 2011 7:13 pm


Return to ECL Watch

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron