Testing to See if RPG2SQL Integrator PC Server Component is Running
From Support
If a user is getting a -999 error from the RPG2SQL Integrator, the problem is usually caused by a few potential issues:
1.) The RPG2SQL Integrator is not licensed for the AS/400.
To check this, run the DSPJOBLOG command from the AS/400 command line after running a program that uses the RPG2SQL Integrator and then look for the following message in the job log:
RJS2SQL product not licensed -or- RPG2SQL product not licensed
If this error is displayed, you need to either enter the access code as provided by RJS or contact RJS to receive a software access code.
2.) The RPG2SQL Integrator is not running on the PC server as required.
Telnet can be used from the AS/400 command line to see if the RPG2SQL Integrator is running on a PC.
From the AS/400 command line, type the following command. This example assumes an IP address for the PC server component of: 1.1.1.1
TELNET RMTSYS('1.1.1.1') PORT(22001)
If telnet connects to the RPG2SQL Integrator PC component, the following messages will be displayed:
111 Connected to RPG2SQL Server 100 SQL 999 ERRNO SQL operation called 199 EOF 100 SQL 999 ERRNO SQL operation called 199 EOF
To exit the TELNET session from CA/400 5250 emulator, hold down the LEFT SHIFT key and press the ESC key while holding the shift key. When the line appears at the bottom of the screen, type the number 2 and press Enter to exit the TELNET session and return to the AS/400 command line.
3.) The IP address of the PC running the RPG2SQL Integrator PC Server has changed, so you're possible connecting to the wrong PC IP address.
From the PC, select Start/Run and type: CMD and click OK
Type: IPCONFIG and press Enter to display the current IP address for the PC.
After reviewing the IP address, you should use the displayed IP address from the AS/400 when running RPG2SQL Integrator programs.
If none of these methods resolves the problem, contact RJS ofr assistance.
