Table Conversion from foreign table in DB2 to E1 table in MS SQL

Hello List,

I am trying to design a table conversion report to migrate data from world softwere in DB2 to E1 in MS SQL Server.
The problem that I am having is that I am not able to assign data items of string type from the foreign table to a data items in the E1 table even it has the same type String.

as example:
if I try to convert F0901 from WS DB2 to E1 F0901 MS SQL server at the event rule desgin I am not able assign CO data item from forign tbale to CO data item in the E1 table. while types other than string is working such as numaric.

I am using E1 8.11 Sp1 with 8.98 win2k3 , MS SQL Server 2005


steps to reproduce your issue.:
1- Create a foreign environment. mapped to world software database
2- create table conversion report to migrate data from db2 to ms sql server 2005 for example F0901
3- during the design of the report click on advanced event rule
4- click on (=) button
5- in the left list select OC CO
6- in the right list IC CO dose not appear.

Hi,

Why don't you do it directly from SQL Server, via DTS or
its SQL2005 equivalent?

Sebastian - can't use SQL Server as there is no driver to read the AS400 DDS format. You have to use a TC or purchase a driver (ie Host Transformation Server).

Hi,

Yes, you can do it.

You right click on your database, Import, then you
select your datasource which is .NET Framework ODBC
something, you'll have to type the DSN and connect strings.

Of course, you previously should have installed the
iSeries ODBC driver on the machine where you run the import.

The iSeries ODBC driver comes with IBM Client Access.

got it,
It was my mistake, in the iseries odbc settings I did not check the translation option check box. For that reason E1 was reading all the world software table fields as binary while they are strings.

thanks