I have a very large file on my iSeries 400 and I want to use SQL. I want to access records page wise. There is some clause like "LIMIT" in mySQL by which I can limit my resultant records to "n" number starting from a particular offset. How can I get similar functionality in iSeries?
As per the mySQL documentation, you can use the following:
SELECT article, dealer, price
ORDER BY price DESC
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Dig Deeper on RPG iSeries programming
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.