DB2 DataAdapter for dOOdads

[jpvanheerden]

Hi folks

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);
becomes
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

Jean-Pierre

[jpvanheerden]

I have noticed that many of our DB2 tables (iSeries) do not have Primary keys. This is apparently normal for these types of tables in our ERP system.

This obviously causes problems for the templates that create the Business Entity layer and the stored procedures.

I am considering acouple of options to get around this

(a) change the template so that you can specify the PKs
(b) script the production tables in another library, create PKs and then run the templates

Anybody in a similar situation have any ideas?

Jean-Pierre