DataExport/400

DataExport/400 provides commands for extracting full or partial data sets from physical and logical files, and exporting them to the IFS. Supported forms include CSV, SLK, DBF, TBL, SV, and others. It installs as the RJSEXPORT library, and is required for select commands in SMTP/400.

Latest documentation for DataExport/400

View all DataExport/400 Documentation

Installing or Upgrading your DataExport/400 Software

DataExport/400

Version 1.44.1 - Installation | Upgrade | Revision History

Licensing DataExport/400

Applying a License

  1. On an iSeries command line, run CALL QCMD for a longer command line.
  2. Copy the RJSEXPORT/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: DataExport/400
    RJSEXPORT/PRDSEC DTAARA(RJSEXPORT) DTALIB(RJSEXPORT) SECURITY('1710A0E000003D0D200DE0D0810110A0110001901080100000') 

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

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

    DataExport is now installed and licensed on the iSeries.

Verifying an Existing License

  1. On an iSeries command line, run the RJSEXPORT/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 RJSEXPORT/RJSEXPORT 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 RJSEXPORT, 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 RJSEXPORT 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 RJSEXPORT 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 RJSEXPORT, 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

DataExport/400 Documentation

(1.01)

Administrator Guide (Version 1.01 | January 2001)

Download PDF|HTML

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

 

Fatal error: Call to undefined function curl_init() in /home/rjs/public_html/support.rjssoftware.com/modules/php/php.module(80) : eval()'d code on line 3