Q
Problem solve Get help with specific problems with your technologies, process and projects.

"LIMIT" clause in mySQL

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
FROM shop
ORDER BY price DESC
LIMIT 1

==================================
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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close