Using SELECT with LIMIT clause on a physical file

30 pts.
Tags:
IBM iSeries
MySQL
Oracle SQL
Pagination
SQL Select
Hi - I'm new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

Software/Hardware used:
iseries

Answer Wiki

Thanks. We'll let you know when a new response is added.

Tom – thanks for the additional information.

A Jakusz

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...wanted to know if you can use mysql SELECT with the LIMIT clause... No, primarily because MySQL isn't standard SQL (like most SQL implementations, including DB2). The LIMIT clause is specific to MySQL. However, if you can supply the DB2 version/release, I might have examples you can use to give similar results. You might find pagination on PHP with db2 and Pagination with PHP and DB2 (scrollable cursor, no OLAP) useful for some background info. Also, MySQL has been ported to i5/OS to use Db2 as a storage engine in the latest releases of the OS. If you are lucky enough to get it installed (I'm not), you might simply be able to use your MySQL syntax directly. That's a very recent possibility, so I only mention it for completeness. I have no direct experience, not even pre-release/beta. Tom
    125,585 pointsBadges:
    report
  • jakusza
    Hi Tom - thank you for your prompt reply. We are V5R4 and plan to upgrade to V6 within the next month. Not sure if that release wil have the capablities you mentioned. Thanks again. A Jakusz
    30 pointsBadges:
    report
  • TomLiotta
    Added info -- MySQL and the DB2 Storage Engine for IBM i. Note that it's not exactly the 'capabilities' of the system. It's mostly an install of an open-source product. As with many open-source products, you can install it and run it as you choose. If you get serious about it, you can obtain a support contract. It seems worth investigating even with its current limitations. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following