In MetaModel 1.6 we've added support for Fixed width value files. Such files are common mostly in legacy systems but it still shows to be quite valuable to be able to read them.
To create a DataContext based on a fixed width value file, use the corresponding factory method:
DataContext dc = DataContextFactory.createFixedWidthDataContext(...);
We've been in contact with quite a few users using IBM's DB2 database and in close cooperation we've managed to make the nescesary changes to the SQL-generation that was needed to make DB2 work.
We've added a feature to the Query API so that you can specify the first row (aka. query offset) that you want in your result. This allows for much better paging capabilities, in combination with the existing "max rows" property.