Question Re: Migration to SQL server from iSeries in Technology Q&A

Migration to SQL server from iSeries

Former Member — Mon, 22 Jan 2007 16:26:25 GMT

Hello,

We are about to begin a migration from iSeries to SQL server environment. In our SAP iSeries environment, we have several rpg and cl programs that we use to communicate with external systems and interfaces. We're going to need to convert these programs to work in the Windows world. Can anyone offer suggestions/recommendations for programming tools to replicate our rpg and cl functionality in Windows?

Thanks,

Bruce Eppensteiner

Re: Migration to SQL server from iSeries

Former Member — Tue, 23 Jan 2007 08:01:05 GMT

Hi Bruce,

I guess, you ran into this position, as you directly access the DB2/400 with RPG etc.

This is note recommended by SAP.

One of the "official technqiues" would be to use RFC-Interfaces between both worlds. These interfaces are independent of the SAP platform => you can now move the interface to this new technique already, test them and later on at the migration, no changes are required.

That means, that you have to exclude your file access to the SAP and replace it with an RFC call and "the rest" of your current RPG can stay.

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

Message was edited by:

Volker Gueldenpfennig

Re: Migration to SQL server from iSeries

Former Member — Tue, 23 Jan 2007 19:33:16 GMT

Hello Volker,

Actually, we're not directly accessing the database. We're using rpg to do things like copying spool files to the ifs as stream files. We use the ifs a lot as a communications structure between SAP and external systems. What i'm trying to find out is what kind of scripting languages may be available to replace our rpg since we're going to be moving to a Windows environment.

Regards,

Bruce

Re: Migration to SQL server from iSeries

Former Member — Wed, 24 Jan 2007 13:42:43 GMT

Hi Bruce,

I would try to change the IFS CPY CL Commands to ftp scripts, because this could be easily converted to windows later ...

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de