Playing around with the DB2 Adapter some more revealed that DB2, as expected as its own unique syntax for SQL statements. Not so great if you come from the SQL server background.
SQL Syntax: Select top 10 * from [TABLE]
What is this in db2 SQL?
Select * from [TABLE] FETCH FIRST 10 ROWS ONLY
Many thanks to: http://en.wikipedia.org/wiki/Select_(SQL)