RPG2SQL

RPG2SQL is a programming toolkit for sending and receiving data from any data source that supports ODBC. There is an iSeries library (RJSRPGSQL) and a required PC component, which can be run as an application or as a service. A supplementary set of functions is available for working with Excel spreadsheets. Sample source files are provided with the library.

Latest documentation for RPG2SQL

View all RPG2SQL Documentation

Installing or Upgrading your RPG2SQL Software

RPG2SQL

Version 1.58.0 - Installation | Upgrade | Revision History

RPG2SQL PC Component

Version 1.0.64 - Installation | Upgrade | Revision History

Licensing RPG2SQL

Applying a License

  1. On an iSeries command line, run CALL QCMD for a longer command line.
  2. Copy the RJSRPGSQL/PRDSEC command from the licensing email from RJS Software. See the sample licensing email below:
    --------------------------------------------------
    AS/400-iSeries-IBM i Access Codes

    S/N:1000000 M#:M4A LPAR:1 Exp:00/00/0000

    *INSTRUCTIONS* - Copy and paste the access code to a 5250 command line and press Enter to apply the code.
    CALL QCMD from the command line to show a multi-line command line.

    Product Name: RPG2SQL
    RJSRPGSQL/PRDSEC DTAARA(RJSRPGSQL) DTALIB(RJSRPGSQL) SECURITY('1710A0E000003D0D200DE0D0810110A0110001901080100000') 

    For assistance contact RJS Software Systems Support
    Email: support@rjssoftware.com
    Tel: (952)736-5800
    Fax: (952)736-5801
    --------------------------------------------------

  3. Paste the RJSRPGSQL/PRDSEC command in the iSeries command line.
  4. Press Enter.

    RPG2SQL is now installed and licensed on the iSeries.

Verifying an Existing License

  1. On an iSeries command line, run the RJSRPGSQL/PRDINFO command to view your OS/400 level and your iSeries series, model and LPAR numbers. They will display at the bottom of your screen, in the format: OS/400 Level: ___ Model: ___ Serial#: _______ LPAR: _.Copy these values into an email.
  2. On an iSeries command line, run DSPDTAARA RJSRPGSQL/RJSRPGSQL to display your current license. Copy the license value to your email, as well.
  3. Send the email to RJS Software Technical Support at support@rjssoftware.com, with the above information, your name, and the name of your company.

Requesting a Demo/Disaster Recovery/Temporary License

You can get temporary licenses, free of charge, for demo and disaster recovery purposes, or by arrangement.

  1. Get the serial, model and LPAR numbers for the system you want to license.
    1. If you've already installed RJSRPGSQL, you can use the instructions at Verifying an Existing License, Step 1, above.
    2. Otherwise:
      1. If you are running OS/400 V5R3 or above, open the Electronic Service Agent menu (GO SERVICE) and take option 6 (Display service agent registration information). Your serial, model and LPAR information will display.
      2. If you are running OS/400 V5R1 or V5R2, run the STRSST command and login to get to the System Service Tools (SST) menu. Take option 5 (Work with system partitions) to view your LPAR number (referred to here as partition identifier).
        Alternately, you can use the system command DSPSYSVAL QSRLNBR to obtain your serial number, and DSPSYSVAL QMODEL to get your model number. If you do not know your LPAR number, you may need to call IBM and get it by providing your serial number.

Transferring Licenses

Since RJSRPGSQL is licensed per LPAR, moving the library to another LPAR, even on the same hardware, requires a modified license. If you need to keep the old LPAR in production while the new LPAR is tested, request a temporary license using the instructions above for the new LPAR. Once you have removed RJSRPGSQL from the old LPAR, use these instructions to obtain a permanent license for your new LPAR.

  1. Getthe serial, model and LPAR numbers for the system you want to license.
    1. If you've already installed RJSRPGSQL, you can use the instructions at Verifying an Existing License, Step 1, above.
    2. Otherwise:
      1. If you are running OS/400 V5R3 or above, open the Electronic Service Agent menu (GO SERVICE) and take option 6 (Display service agent registration information). Your serial, model and LPAR information will display.
      2. If you are running OS/400 V5R1 or V5R2, run the STRSST command and login to get to the System Service Tools (SST) menu. Take option 5 (Work with system partitions) to view your LPAR number (referred to here as partition identifier).
        Alternately, you can use the system command DSPSYSVAL QSRLNBR to obtain your serial number, and DSPSYSVAL QMODEL to get your model number. If you do not know your LPAR number, you may need to call IBM and get it by providing your serial number.
  2. Copy the following template into a blank document:
    M DD, YYYY
    RJS Software Systems, Inc.
    PO Box 1408 Burnsville, MN 55337
    To Whom It May Concern:
    YOUR COMPANY NAME has recently removed all software provided by RJS Software Systems from the iSeries partition with Serial Number __________, Model Number ___and Partition Number _. This software will no longer be run on this iSeries. The software will be installed on the iSeries partition with Serial Number __________, Model Number ___and Partition Number _ and executed on this partition.
    Sincerely,
    (SIGNATURE)
    (YOUR NAME)
    (YOUR COMPANY NAME)
  3. Replace the underlined sections with the appropriate information.
  4. Print on company letterhead, and sign at the bottom.
  5. Email a PDF or TIFF copy to support@rjssoftware.com, or fax a copy to (952) 736-5801. You should receive a response by close of the soonest business day.
    Note: Change out requests will be rejected if they are:
    • Not signed
    • Not on company letterhead
    • Not in TIFF or PDF format (if emailed)
    • Missing/incomplete/incorrect serial/model/LPAR information

RPG2SQL Documentation

(1.50)

User Guide (Version 1.50 | March 2011)

Download PDF|HTML

Search our Troubleshooting Knowledge Base

Top Troubleshooting Issues:

Is RPG2SQL compatible with V6R1 and V7R1?
Applies to: RPG2SQL | Last updated: March 22, 2012
What version of the RPG2SQL library is installed?
Applies to: RPG2SQL | Last updated: March 22, 2012

Contact Technical Support

Are you an existing RJS customer needing technical help?

Phone

Call Us: 1 (888) 757-7638
Hours: Mon-Fri 8am to 5pm CST