Skip to Content
0

JDBC-JDBC Sending 100 records at a one interval?

Feb 07 at 06:50 AM

39

avatar image

Hi folks,

How to send 100 records at one interval instead of sending entire data at once i want to send partially .can you please give me an idea thanks?

is additional parameter works for this req?

Regards,

Bhaskar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Andrzej Filusz Feb 07 at 10:24 AM
0

Hi Bhaskar,

I think you could write the select statement that reads up to 100 records only. How to do it? It depends on your source database. Please check your DB documentation or google "how to select up to n rows" with your DB name.

Best Regards,

Andrzej Filusz

Share
10 |10000 characters needed characters left characters exceeded
Pavan Dogiparthy Feb 07 at 11:53 AM
0

Hi Bhaskar,

you can write sql select statement in below format in jdbc sender channel.

select * from tablename where rownum<=100

Note: Get the table name from DB team.

Regards

Pavan

Share
10 |10000 characters needed characters left characters exceeded
Priyanka Anagani Feb 07 at 10:20 AM
0

There are 2 ways to achieve this.

1. Select only first 100 records that matches your query at a time and update them. You need to mention that in the SELECT statement in JDBC sender channel.

2. Pick all records and then split them into multiple messages in mapping so that each will have 100 records.

I would suggest the first one as selecting all of them at once might cause performance impact.

---Priyanka

Show 1 Share
10 |10000 characters needed characters left characters exceeded

yes sure it works thanks

0