Migration to SQL server from iSeries

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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