EPC - 838

Date : 20th April 2009

EPC838 Highlights

This EPC delivers 

  • LANSA Database Triggers Support.  LANSA validation rules and trigger functions can now be executed from outside of LANSA when LANSA DB Triggers are enabled for a file.  What does this mean?  Programs written in languages other than LANSA (e.g. RPG) can now be subjected to same LANSA Repository Business and Data Validation Rules as programs written in LANSA's RDML. 
  • Support for Visio 2007 in the logical modeler.
  • A collection of recently released patches and hotfixes

ProductVisual LANSA and LANSA for iSeries
Version11 SP5
Pre-Requisite DetailsEPC834 and IBM supported operating systems
Related ProductsNone
Full Distribution InV12
Special NotesAll Version 11 SP5 Visual LANSA EPCs include updates that must be applied to Windows and System 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.
System i Specific Special NotesThe System 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 ActionsCCS items 137189/137217 require user action.
Note: EPC837 included CCS items 136567, 136628, 136667 and 136981 that required user action.
See below for details
Document UpdatesUpdates to these guides are provided:
  • lansa009.chm Introduction to LANSA for iSeries Guide
  • lansa013.chm Visual LANSA Developer Guide
  • lansa015.chm Technical Reference Guilde
  • lansa016.chm Visual LANSA Feature Help
  • lansa020.chm Deploying Visual LANSA Applications Guide
  • lansa065.chm LANSA Application Design Guide
The guides updated by EPC are only placed in the default LANSA documentation location as installed with Visual LANSA. This default location is ...\x_win95\x_lansa\execute\eng directory. If you installed the LANSA documentation (default folder ...\lansadoc\) from the LANSA Windows CD-ROM, you should manually copy the updated guides to those folders.

The latest guide updates are also available at www.lansa.com/support/docs/update.htm
HotfixesThe following Hotfixes will be replaced by this EPC:
Windows:
EPC830HF-081120
EPC830HF-081120a
EPC830HF-081120b
EPC830HF-081202
EPC830HF-090122
EPC830HF-090202
EPC834HF-081201
EPC834HF-081203
EPC834HF-081211
EPC834HF-081216
EPC834HF-081217
EPC834HF-081223
EPC834HF-090109 		EPC834HF-090114
EPC834HF-090116
EPC834HF-090129
EPC834HF-090129a
EPC834HF-090209
EPC834HF-090219
EPC834HF-090226
System i:
EC830P07
EC834P01
EC834P02
EC834P03
If you have applied a patch to your environment that is not listed here contact your local LANSA vendor for instructions before applying the EPC.

Instructions to install the EPC

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

  1. Download EPC838.EXE file from the Web site or email.
  2. Unzip (double click) EPC838.EXE. These files will be extracted:
    • EPC838.htm - this document
    • EPC838 - System i Save file
    • EPC838w.exe - Windows Visual LANSA install executable

Instructions provided for:

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

Detailed changes

EPC838 includes these changes:    [Click here to Hide table...]

EPC838 supercedes EPC837 which included these changes:    [Click here to Hide table...]

Affected objects

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

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

Install Instructions

Instructions for installing on System i

These instructions have been abbreviated for experienced LANSA users. If you need further assistance to install the EPC, full instructions are available in the Technical Resources of the LANSA web site at www.lansa.com/support/notes/epc.

  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 System 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 EPC838 to an IFS folder on the System i. ( e.g. /LANSA_pgmlib/tmp/epc838' )
  6. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = FULL_LANSA_SYSTEM
  7. Run the command LOADEPC with the following parameters:

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

    EPC number . . . . . . . . . . . > 838

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

    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib
     
  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 EPC838w.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

© 2009 LANSA

Back to Top