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

Detailed changes

CCS id.Description
EPC851
130778IBM i: EPC will now be registered in the EPC log by Product.

The EPC log file on IBMi, DC@FEP, will now hold EPCs by product option.
BAS = base LANSA
INT = Integrator
VLF = Visual LANSA Framework.
The EPC Log display (which can be viewed from the LANSA ABOUT then F10) will now show this information.
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.
Any data in file DC@FEP will be converted to the new format.
After the conversion of file DC@FEP if you install previously issued Integrator EPC835 or VLF EPC843 they will be registered with their appropriate product/option code.
0133307
0140010
OTHER file issue where the S/36 file has a '.' in the record format name

An IBM i S/36 file with a '.' in the record format name can now be loaded as an Other File in the Visual LANSA IDE.
0134910Missing objects when try to deploy translations package

The translation tool can now be deployed as a standalone application
138199
138213
138893
138894
139223
Ensure that the XSL Editor can use Internet Explorer 6, 7 as well as 8

Hidden fields are not displayed in the XSL Editor's Web designer.

IE8 is no longer displaying help design borders for those HTML elements which do not already have borders, either via a border attribute or via CSS border settings, as it used to do in previous versions of IE. Therefore the XSL Editor will simulate design borders for IE8. When the mouse is over an HTML element, when performing a drag operation or moving the mouse, the XSL Editor will temporarily show a design border around the HTML element that the mouse is over. As soon as the mouse moves away from the HTML element the design border will disappear. In some cases, such as tables, design borders will also be applied to the parent HTML element, such as table and the table cell (<td> or <th>) that the mouse is currently over.
0138546Random Access violations in W3_P1200 when running Web Application
0138966
0140528
FUNX output attribute only writes first 7 characters when updated from function

Fields with either the FUNX or FUNU output attribute will now blank out the characters beyond the first seven when inserted or updated by an RDML function on IBM i.

User Action:
Recompile any I/O modules for files containing fields with FUNX or FUNU output attributes. In addition recompile functions that have any of the function options *DBOPTIMISE, *DBOPTIMIZE, *DBOPTIMISE_BATCH or *DBOPTIMIZE_BATCH.
0139304
0140360
STD_LISTBOX Weblet doesnt work consistently between MS IE 7 and Firefox Browser

In non-IE browsers, a List Box weblet with multi-select on does not remember the initial selected items passed to it from the webroutine. It renders them correctly and any user interaction with the list will fix the issue but, if the user does not interact with the list, the selected values are not re-submitted to the next webroutine.
0139407Allow selection of fields for Add Record page in WAM CRUD wizard
0139772
0139596
LWEB_JOBs not terminating on Windows causing performance degradation

Orphaned Web Jobs are now detected and cleaned up corrrectly.
0139824Duplicate key in dc@W19 errors and lweb_job taking all the CPU cycles

Fixed to clean up DC@W19 correctly when using <RDML MERGE="&END">
0139831Navigation panel doesn't work in Chrome

Navigation panel wouldn't load in Chrome (Note: the asynchronous loading property must be "True"). This defect has now been rectified
0139893XSL Editor: Hidden fields are displayed using IE8

Fields which are hidden are no longer displayed.
0139894XSL Editor: Help border around tables is not visible using IE8

Help border is now shown around HTML tags when the mouse hovers over an element which does not have all borders defined. Note that help borders are not drawn around XSL tags etc, just around HTML tags.
0139965LceRequest: Second Select does not returns the expected records
0140001
0140381
Enhancements to 5250 debugger

1. New Function key to select all variables on Choose Variables screen
2. New functiion key to step next on main debug screen while debugging
3. New function key on main debug screen to hide / show variables so that more lines of RDML can be seen.
0140027XSL Editor: Preview throws exception when calling a webroutine

This defect has now been rectified
0140085XSL Editor: Show HTML tags attributes options, such as <td align="???">

Now showing available options for attributes for html tags
0140184DEF_ARRAY behaves differently on IBM i compared to Windows
0140215Deliver To iSeries does not work with Object Locking off in the IDE

This defect has now been rectified
0140223
0139940
0139957
Second update of a file ends an error in LANSA Open V11 SP5
0140262
0140426
LANSA Object Translation Interface updated

The LANSA Object Translation tool set has been updated to include :
- Support for RDMLX objects (129822)
- Support for translation of web components
- Ability to select location where translation files are loaded from

Support has been removed for :
- Process Action Bar translation
- creation of ZIP files including translation files
0140322Binary.AsString intrinsic presumes VarBinary is nul terminated
0140457Refresh inlined weblets required for CRUD Wizard generated WAMs

This defect has now been rectified
0140463CRUD wizard creates WAM with corrupted service name containing blanks

This defect has now been rectified
0140515IBM i: ODBC column length less than returned field size on DELETE or UPDATE

Note: Only occurs on LANSA files which have a char or binary with length over 32765, or that have a varchar or varbinary wth length > 32739; these are implemented in the DB2 database as a CLOB or BLOB.

User Action:
Check-in/Compile the OAM for affected files that have been built with Visual LANSA 11 SP5 + EPC845 or later, or V12 or later. Files built with an earlier version are not affected.
0140532
0140507
File compilation error when lookup file has trigger function and DB triggers

File compilation (I/O module) will now succeed when a lookup file has a trigger function and that lookup file has DB Triggers enabled.
0140572Restore V11 SP5 Editor WordWrap functionality

The V11 SP5 Editor WordWrap Options for None\Simple and Smart have been restored and the V12 introduced behavior of WordWrap True\False has been removed
0140583#PRIM_TAB class no longer has the currentpage property

Tab.CurrentPage feature that was available in V11 SP5 and was missing from the V12 release has been restored
0140590RENAME behaviour leads to data not being selected
EPC852
0139514Push button weblet set as Default Button doesn't work in Google Chrome browser

This defect has now been rectified
0139748Operation aborted message in IE occurs when table and nav panel on the screen

Navigation panel's onload() Javascript causes the HTML parser to stop parsing the document (Can happen in large documents).
This defect has now been rectified
0140412STD_NAV_PANEL resize problem after applying EPC848

Navigation panel not resizing to content size when requested to do so.
This defect has now been rectified

Affected objects

Object NameObject Type
EPC851
LansaAutoImport.exe\LANSA
liih.exe\LANSA
liio.dll\LANSA
liix.dll\LANSA
liiy.dll\LANSA
x_prim.dll\LANSA
XSLEditorFrame.dll\LANSA
XSLEditorFrameFRA.dll\LANSA
XSLEditorFrameJPN.dll\LANSA
lxxfws.asc\lansa\imports\std_weblets
lxxfwx.asc\lansa\imports\std_weblets
PreviewBrowser.dll\lansa\XslEditor\
PreviewBrowserFRA.dll\lansa\XslEditor\
PreviewBrowserJPN.dll\lansa\XslEditor\
XSLEditor.dll\lansa\XslEditor\
XSLEditorFRA.dll\lansa\XslEditor\
XSLEditorJPN.dll\lansa\XslEditor\
XSLHTMLEditor.dll\lansa\XslEditor\
XSLHTMLEditorFRA.dll\lansa\XslEditor\
XSLHTMLEditorJPN.dll\lansa\XslEditor\
XSLTextEditor.dll\lansa\XslEditor\
XSLTextEditorFRA.dll\lansa\XslEditor\
XSLTextEditorJPN.dll\lansa\XslEditor\
letw0202.dll\X_WIN95\X_LANSA\Execute
letw0203.dll\X_WIN95\X_LANSA\Execute
letw0204.dll\X_WIN95\X_LANSA\Execute
letw0211.dll\X_WIN95\X_LANSA\Execute
levfd021.dll\X_WIN95\X_LANSA\Execute
levfd045.dll\X_WIN95\X_LANSA\Execute
levw0201.dll\X_WIN95\X_LANSA\Execute
levw0202.dll\X_WIN95\X_LANSA\Execute
levw0208.dll\X_WIN95\X_LANSA\Execute
levw0209.dll\X_WIN95\X_LANSA\Execute
levw0210.dll\X_WIN95\X_LANSA\Execute
levw0213.dll\X_WIN95\X_LANSA\Execute
lp_dpctl.dll\X_WIN95\X_LANSA\Execute
lp_dply.dll\X_WIN95\X_LANSA\Execute
lp_trlt.dll\X_WIN95\X_LANSA\Execute
lp_trltl.dll\X_WIN95\X_LANSA\Execute
lp_xrt.dll\X_WIN95\X_LANSA\Execute
lpfpth01.dll\X_WIN95\X_LANSA\Execute
lpinstl.dll\X_WIN95\X_LANSA\Execute
lpsrvdpl.dll\X_WIN95\X_LANSA\Execute
lpvtrl01.dll\X_WIN95\X_LANSA\Execute
lpvtrl02.dll\X_WIN95\X_LANSA\Execute
w3_p2000.exe\X_WIN95\X_LANSA\Execute
w3wprfun.dll\X_WIN95\X_LANSA\Execute
w3wsvpgm.dll\X_WIN95\X_LANSA\Execute
X_FUNMS.DLL\X_WIN95\X_LANSA\Execute
X_LSV.DLL\X_WIN95\X_LANSA\Execute
x_prim.dll\X_WIN95\X_LANSA\Execute
X_Var.dll\X_WIN95\X_LANSA\Execute
iom00001.s\x_win95\x_lansa\source
wiz00001.sss\x_win95\x_lansa\source
wiz00001fra.sss\x_win95\x_lansa\source
wiz00001jpn.sss\x_win95\x_lansa\source
EPC852
crud_fluid_header_left.gifWebServer\images\crud\themes\bluefluid
std_script_v2.jsWebServer\images\script
std_style_crud_blue_fluid.cssWebServer\images\style
Object NameObject TypeLibrary
DC@FEP*FILE(PF)LANSA program library
DC@FEPV1*FILE(LF)LANSA program library
DC@FEPV2*FILE(LF)LANSA program library
DC@FEPV3*FILE(LF)LANSA program library
DC@FEPV4*FILE(LF)LANSA program library
DC@FEPV5*FILE(LF)LANSA program library
DC@FEPV6*FILE(LF)LANSA program library
W3XSVPGM*SRVPGMLANSA communication library and Web Server
W3XSVPGV*SRVPGMLANSA communication library and Web Server
D@DEBUG2*DSPFLANSA program library
DC@D8600*DSPFLANSA program library
@LPINSTL*SRVPGMLANSA program library
W3PROFUN*SRVPGMLANSA program library
X_BASE*SRVPGMLANSA program library
X_COMP*SRVPGMLANSA program library
X_DBG*SRVPGMLANSA program library
X_FUN*SRVPGMLANSA program library
X_LSV*SRVPGMLANSA program library
X_PRIM*SRVPGMLANSA program library
X_VAR*SRVPGMLANSA program library
DC@FEP*PGMLANSA program library
DC@P2121*PGMLANSA program library
DC@P2255*PGMLANSA program library
DC@P3123*PGMLANSA program library
DC@P8600*PGMLANSA program library
DC@P8601*PGMLANSA program library
DC@P8601D*PGMLANSA program library
DC@P8601E*PGMLANSA program library
DC@P8606*PGMLANSA program library
F@DEBUG2*PGMLANSA program library
W3@P1400*PGMLANSA program library
EPC851IMG(/script)*IFSLANSA IFS Objects
EPC851IMG(/style)*IFSLANSA IFS Objects

Install Instructions

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

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
  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