EPC - 851

Date : 25 February 2010

EPC851 Highlights

  • IE8 support added for WAM development using the XSL Editor. The XSL Editor can now use Internet Explorer 6, 7 as well as 8.
  • IBM i: EPC will now be registered in the EPC log by Product. This change will allow more accurate checking of EPC relationships in the loading and pre-requisites of EPCs and in the EPC checking done in Client/Server connections.
  • Various enhancements to the 5250 debugger.

ProductVisual LANSA and LANSA for iSeries
LANSA for the Web (EPC852 on windows)
Version12
Pre-Requisite DetailsNone
Related ProductsNone
Special NotesAll Version 12 Visual LANSA EPCs include updates that must be applied to Windows and IBM i systems (Independent Visual LANSA development environments only require the Windows updates). Failure to upgrade both sides of a development environment will render the Host Monitor and Super Server applications inoperable. Attempting to use the Host Monitor and Super Server applications without having applied the EPC to both sides of a development environment will generate an EPC mismatch error.

Make a full backup of your LANSA environment on each platform to which this EPC will be applied.
IBM i Specific Special NotesThe IBM i instructions are expedited procedures that assume a sound knowledge of i5/OS.
You should use a user profile that is QSECOFR, part of the QSECOFR group, or, has *ALLOBJ and *SECADM special authorities.
You must end the web server and run the LANSA for the Web cleanup program before applying this EPC.
You must end the Listener and Host Monitor if active.
You must end the LANSA Integrator server if it has been used with the LANSA system to be updated.
User ActionsThe following CCS items require user action:

138966 FUNX output attribute only writes first 7 characters when updated from function
140515 IBM i: ODBC column length less than returned field size on DELETE or UPDATE

See below for details.
Document UpdatesThis EPC does not contain updates to any guides.
The latest guide updates are available at www.lansa.com/support/docs/update.htm
HotfixesThe following Hotfixes will be replaced by this EPC:
Windows:
V12HF-1001280 
IBM i:
none

Instructions to install the EPC

EPC851 includes software to be installed on an IBM i machine and on a Windows machine. These instructions describe the installation and use of all delivered items.

  1. Download EPC851.EXE file from the Web site or email.
  2. Unzip (double click) EPC851.EXE. These files will be extracted:
    • EPC851.htm - this document
    • EPC851 - IBM i Save file
    • EPC851w.exe - Windows Visual LANSA install executable
    • EPC852w.exe - Windows web server install executable
    • AllEPCs.exe - Windows multiple EPC installer
    • AllEPCs.ini - AllEPCs control file

Instructions provided for:

YesLANSA for iSeries
YesIBM i Web Server (multi-tier)
YesVisual LANSA

Detailed changes

EPC851 includes these changes:    [Click here to Show table...]

Affected objects

Windows Components:    [Click here to Show table...]

IBM i Components:    [Click here to Show table...]

Install Instructions

Instructions for installing on IBM i

Note: Install Instructions have changed

  1. Sign on with QSECOFR user profile, part of the QSECOFR group or a user profile that has *ALLOBJ and *SECADM special authorities.
  2. Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_pgmlib/x_lansa) before applying this EPC
  3. You need exclusive use of the LANSA system before applying the EPC. To check for active users refer to Appendix C How to check for Active Users in the Installing LANSA on IBM i guide for instructions.
  4. End the Listener, Host Monitor and Web Server for the LANSA system and run the LANSA for the Web cleanup program.
  5. Move the unzipped file EPC851 to a shared folders (QDLS)  on the IBM i. ( e.g. /QDLS/epc851' ) 
  6. Use the XFLRTOSAVF command to convert the folder to a save file (LANSA program library must be on your library list) - press F4 for command details. A save file will be created by this command.
  7. Use the RSTOBJ command to restore the following objects into QGPL library.
    RSTOBJ OBJ DC@LCP120 LOADEPC SAVLIB(QTEMP) DEV(*SAVF) SAVF(<save file name>) RSTLIB(QGPL)
  8. For this EPC use the following options:
    1. Install the EPC from = *SVF
    2. Apply this EPC to = FULL_LANSA_SYSTEM
  9. Run the command LOADEPC with the following parameters:

    QGPL/LOADEPC and press command 4 (F4) to prompt the command (can be run in batch)

    EPC number . . . . . . . . . . . > 851

    Install the EPC from . . . . . . > *SVF

    Save file . . . . . . . . . . . > Name of the save file
    Library Name . . . . . . . . .  Library where the save file is
    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib
     
  10. Save and then delete the backout library (iiiEPCnn where iii = 1st three characters of the LANSA pgm library and nn is sequence number) created by the install. The contents of the library may be used to backout this EPC and return your system to its previous state.
  11. Delete from QGPL DC@LCP120 program and LOADEPC command
  12. Sign off and then on again before commencing the next installation, e.g.:
    • to apply this EPC on another LANSA system
    • to apply another EPC on the same LANSA system

Instructions for users of IBM i Web Server (multi-tier)

The command LOADEPC is now available in the LANSA web server Admin library. Use the following instructions.

  1. If you haven't installed or upgraded LANSA for the Web on the Web Server, do so before proceeding with step 2.
  2. Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_admlib/x_lansa) before applying this EPC
  3. End the Web Server and run the LANSA for the Web cleanup program. Refer to 13.5.6 Clean Up Systems in the LANSA Online documentation for cleanup instructions.
  4. Display your current library list. If QTEMP is not shown, then add it to your library list using the ADDLIBLE (add library list entry) command.
  5. Move the unzipped file EPC851 to an IFS folder on the IBM i. ( e.g. /LANSA_admlib/tmp/epc851' ) 
  6. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = LANSA_WEB_SERVER
  7. Run the command LOADEPC with the following parameters:

    admlib/LOADEPC and press command 4 (F4) to prompt the command (can be run in batch)

    EPC number . . . . . . . . . . . > 851

    Install the EPC from . . . . . . > *IFS
    IFS Path and object name . . . .e.g. /LANSA_admlib/tmp/epc851

    Apply this EPC to . . . . . . . LANSA_WEB_SERVER
    LANSA web server admin lib . . . . .admlib
     
  8. Save and then delete the backout library (iiiEPCnn where iii = 1st three characters of the LANSA pgm library and nn is sequence number) created by the install. The contents of the library may be used to backout this EPC and return your system to its previous state.
  9. Sign off and then on again before commencing the next installation, e.g.:
    • to apply this EPC on another LANSA system
    • to apply another EPC on the same LANSA system

Instructions for installing on Windows

  1. Recommend that a backup be done of all LANSA folders and your LANSA database before applying this EPC.
  2. Stop using the LANSA development environment and stop all currently executing LANSA applications.
  3. Double-click on AllEPCs.exe.
  4. Select the "Setup" button or "Cancel" if you do not want to proceed.
  5. If you have multiple configurations installed, Select the configuration to which the EPC is to be applied.
  6. If you are prompted to reboot your pc - please reboot.
  7. To view details of the installed EPCs:
    1. sign into LANSA
    2. view the Help menu
    3. Product Information option
    4. then select the Installation Details tab
    5. expand the Installation/ EPC Summary
    6. review the last entries

© 2010 LANSA

Back to Top