Thank you so much Erel and Alexander, both your comments made it clear on how I will do this, CLV_ReachEnd and the offset for the limit!! This is great, thank you!
One more question if you do not mind what if i will have search, so does this mean that everytime the user will search for keyword for example: ABC, it will SELECT when the user hit A then another call/select when the user hit B, and then third when hit C?
I believe this can be achieved by clear the first visible 30/100 and use LIKE syntax in jRDC2 side , but what do you think is the best practice for search in jRDC2/CLV to show the output?