• Stephen W. Thomas
  • Azure Integration Gurus
BizTalkGurus
  • Home
  • Blogs
    • Stephen’s BizTalk and Integration Blog
    • BizTalk Community Blogs via Syndication
  • Forums
  • Downloads
  • Videos
  • Training
    • Online Training
    • Classroom Training
Select Page

DB2 SQL Syntax: Select top 10 * from [TABLE]

by community-syndication | Feb 19, 2007 | BizTalk Community Blogs via Syndication

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)

  • Facebook
  • Twitter
  • Google+
  • Gmail
  • LinkedIn

Search this Site:


Recent Posts

  • Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
  • BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
  • BizTalk Oracle Adapter error: The assembly required for type mapping not found.
  • PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
  • Friday (funny) Fact: There is no size limit for the Logic App parameter name

Tweets by AzureIntGurus

Recent Topics

  • Evaluating on the amount of items returned in a message
  • Send and Receive ports problem
  • How to config/costom a WS Security to SOAP header
  • Email attachments – POP3 adapter
  • Calling ASP page from Biztalk Orchestration

  • Home
  • Blogs
  • Forums
  • Downloads
  • Videos
  • Training
  • Facebook
  • X
  • RSS
@BizTalkgurus.com