The use case is a simple one. The user wants to regularly import records from a table. The key column (the only column with consistent data that can be recognized and sorted) is character based. The table I tried on has the column CUSTMERID with the following values:
This is obviously limited. To make this work in a table with new records being added continuously, one needs a scheme like:
Our customers have key columns that are character based quite often.
Anyway, the problem is the code which generates the query to specify the range does not take character values into account.
It is a simple change in ImportTool around line 300
if (checkColumnType == Types.CHAR)
nextIncrementalValue = "'"+nextIncrementalValue+"'";
Everything works fine with that and it does not affect other cases.