After playing around with the DB2 Adapter, I discovered that DB2, as expected, has 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)

Have you ever received the following error Message When using the db2 Adapter for BizTalk? The adapter "DB2 Adapter" raised an error message. Details "UPDATE or DELETE is not allowed against the specified cursor. SQLSTATE: 42828, SQLCODE: -510"   more »