In order to get dOOdads working with iSeries DB2 I had to make various small changes and improvements to data adapters and a template.
Changes are as follows:
Created Db2DynamicQuery.cs, which is OleDbDynamicQuery.cs with [ and ] removed in various places
Created Db2Entity.cs which is OleDbEntity.cs with [ and ] removed in various places
An example of the changes:
base.AddOrderBy (\"[\" + column + \"]\", direction);
base.AddOrderBy (column, direction);
These changes were required as iSeries DB2 doesnt like [ and ] around column and table names.
I have also created a new template (based on dOOdads Business Entity) that is iSeries aware that will give you the option to the use the Data Adapters above instead of the OleDb adapters.
I have created a new archive DB2 DataAdapter for dOOdads and uploaded the files.
See this thread DB2 doesnt like ... for further info