I am trying to paginate my query results. When I use the LIMIT in my SQL statement, I get the following error:
'Token Limit Was Not Valid'
From what I uderstand the LIMIT parameter can't be used with a ODBC_EXEC? If so, is there another parameter I can use in my SQL statement that allows me to specify starting record and limit the number of records in my results?
Using LIMIT in SQL Query
Moderator: General Moderators
meaning: it's a DB2?warrenk wrote:I am trying to pull the results from a AS400 database.
LIMIT is a mysql extension to sql.
Funny, IBM set up a page called
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602tham2/ wrote:Leveraging MySQL skills to learn DB2 Express: DB2 versus MySQL administration and basic tasks
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602tham2/ wrote:However, to limit the resultset being returned, MySQL uses the keyword, LIMIT, while DB2 Express uses FETCH FIRST n ROWS to limit resultset being returned
Or you might read an article about how to achive pagination with db2 
http://www-128.ibm.com/developerworks/d ... alani.html
http://www-128.ibm.com/developerworks/d ... alani.html