I cannot use QueryDatabaseTable for a couple of issues
So the option I have is to use ExecuteSQL. I have already looked at https://community.hortonworks.com/questions/187764/can-executesql-processor-store-state-for-incremen... (I should not store state in Cache) and https://community.hortonworks.com/questions/131610/how-fetch-a-sql-join-result-incrementally.html (In this I dont see the state storing capability)
So both of these are not suitable solutions for my use case.
Can I use any DB2 table for storing state?
Are there any other options than cache for storing state?
@Shu @Matt Burgess @Matt Clarke Appreciate your help in this.