Skip to Content
0
Former Member
Sep 27, 2013 at 03:34 PM

JDBC restrict table entries

20 Views

Hi Experts,

How can I limit reading of JDBC sender adapter for DB so that it will read 500 records in each poll.

Normally we use following SQL statement with success in MSSQL Server

Select top 500 * from [NOVASTOCK].[dbo].[CUSTOMER] where STATUS = '0' and TRANSACTION_DATE between'2012-01-02 00:00:00.001'and'2012-02-01 23:59:55.999'

in JDBC Sender ADAPTER i use the same syntax but i can't pull data.

Thanks

PM