SAP Knowledge Base Article - Preview

1470340 - Limit the number of rows returned in query transform

Symptom

  • What function is required  to limit the number of database records processed or returned from a query transform?
  • Requirement for this function to be similar  to what Oracle allows in a sql query, for example:
     "select * from table_name where rownum <=1000".

                                                                               


Read more...

Environment

  • All BOBJ DATA INTEGRATOR XI R2  versions
  • All BOBJ DATA SERVICES XI 3.x versions
  • Any supported OS platform
  • Oracle 10g

Product

SAP Data Integrator XI R2 Accelerated ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

KBA , EIM-DS , Data Services , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.