cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Sender Adapter - Restrict number of rows fetched, Oracle

Former Member
0 Kudos

Hi,

Is it possible to restrict the number of rows fetched by the JDBC Sender adapter at each run? What would the appropriate Select and Update statements be to make sure a limited number of rows are selected and flagged as processed?

We are connecting to a Oracle RDBMS.

//Johan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Michal,

Thank's for the link. I'm aware of the ROWNUM and think I know how to use it in the select statement, my main question is how the update statement should look like?

rgds Johan

bhavesh_kantilal
Active Contributor
0 Kudos

Johan,

Use the same RowNum Function in the update Query as well.

I have seen a few posts on the Forum which have poitned to the successful selection and updation of the Same data using the rowNum function.

Regards

Bhavesh

MichalKrawczyk
Active Contributor
0 Kudos

hi,

have a look at this info:

about oracle and limiting number of rows

http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html

Regards,

michal

-


<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>