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.