I have been trying to port a SQL server based code to DB2 based. Since I am new to DB2, I dont know what are the commands that are available with DB2. The
Select Top 10 * from TableName SQL Command which works with SQL server 200 doesn't seem to work with DB2, is there any equivalent SQL command in DB2. Also, If anybody can let me know some good DB2 books, it will be of great help to me.
The DB2 manuals can be downloaded in PDF format. You need most of the manuals, especially the SQL Reference (vol 1 and 2). There is also porting information available on the IBM website. To get these links, go to the Useful DB2 Stuff thread.