RPG2SQL Integrator Upgrade

From Support

If you have a question or seek clarification, please call Technical Support.

Use the following instructions for your RPG2SQL Integrator upgrade.

If you encounter any problems, please contact Technical Support

This upgrade will bring RPG2SQL Integrator to version 1.53 For help finding what version you are currently at, please read the FAQ

Note: If you are at version 1.41 or lower you will have to recompile your programs. At version 1.42 or above this is not necessary, unless you are using new functions.

Contents 1 Step 1: Back up old library 2 Step 2: Download 3 Step 3: Install 4 Step 4: Copy DTAARAs 5 Step 5: Clean up

Step 1: Back up old library

RNMOBJ OBJ(QSYS/RJSRPGSQL) OBJTYPE(*LIB) NEWOBJ(RJSRPGSQL1)

Step 2: Download

Download RPG2SQL Integrator from RJS.

Username = *********
Password = ***********

Step 3: Install

Use FTP Library Installation to install RPG2SQL Integrator library (RJSRPGSQL) onto the System i.

Unzip the file to the default location.

Enter your System i IP Address, username and password.

Take each numbered step, waiting until the previous step is finished before continuing.

You will see an Error 550. This is normal behavior. If you see any additional errors please contact Technical Support.

ADDLIBLE RJSRPGSQL

Step 4: Copy DTAARAs

Use the following commands to copy the old DTAARA's and all the users tables to the new library

SQLUPG RJSRPGSQL1 RJSRPGSQL

Step 5: Clean up

Remove the RPG2SQL Integrator library

RMVLIBLE RJSRPGSQL

RPG2SQL Integrator should now be completely upgraded.

This article has been proofread by Jordan as of 14:15, 23 April 2009 (CDT)