EPC - 837
Date : 17 March 2009
EPC837 Highlights
This EPC is a collection of recently released patches.
| Product | Visual LANSA and LANSA for iSeries |
|---|
| Version | 11 SP5 |
|---|
| Pre-Requisite Details | EPC834 and IBM supported operating systems |
|---|
| Related Products | None |
|---|
| Full Distribution In | V12 |
|---|
| Special Notes | All 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 Notes | The 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 Actions | CCS items 136567, 136628 and 136667 require user action. See below for details |
|---|
| Document Updates | This EPC does not contain updates to any guides. The following Help Text will also be added to the online documentation available at www.lansa.com/support/docs/update.htm
Help text included in this document for new XCMD X_RUN parameters shipped in this EPC as 136074. Refer to X_RUN XCMD Parameter Help Text |
|---|
| Hotfixes | The 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 |
| 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
EPC837 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.
- Download EPC837.EXE file from the Web site or email.
- Unzip (double click) EPC837.EXE. These files will be extracted:
- EPC837.htm - this document
- EPC837 - System i Save file
- EPC837w.exe - Windows Visual LANSA install executable
Instructions provided for:
| Yes | LANSA for iSeries |
| No | System i Web Server (multi-tier) |
| Yes | Visual LANSA |
Detailed changes
EPC837 includes these changes: [Click here to Show table...]
| CCS id. | Description |
|---|
| 0135642 | Unlevelled Tree Lists events fire in wrong order
Tree behaviour changed so that an Expand(True) on a Child node that results in Parent items also being expanded will Fire the Parent ItemExpanding events before the child Item expanding event (11.5 fired the child events before the parent events) |
| 0136074 | Obscure X_RUN command line so user ids and passwords cannot be seen
New XCMD command line parameter which when set to Y obscures all user ids and passwords on the command line so they cannot be seen using Process Explorer. See documentation for more details |
0136309 0136849 0136869 | XSL Editor crash when doing pastes or using backspace |
| 0136356 | Expanded property causing corruption of Listcount value |
| 0136529 | SELECT with *Compute does not work for RDMLX Key fields if they are blank |
0136539 0136568 0136571 0136633 0136811 0136827 0137087 0137111 | Defect in List and Grid column sequence
A change introduced in 11.3 to address an issue with SortPosition (number 135349) broke pre-existing behavior. An alternative change has fixed the SortPosition and also restored the pre-existing behavior. |
0136558 0136941 | SAVE_LIST built in crashes in V11 SP5 RDMLX on second invocation
BIFs SAVE_LIST, RESTORE_SAVED_LIST and DELETE_SAVED_LIST fail when invoked a second time when running in an RDMLX web function or WAM. |
| 0136567 | HTML for table views occasionally generates two cells in same row
User Action: The affected HTML needs to be regenerated. |
0136586 0137029 | Grid CurrentItem.Entry causes an error if there are no entries in the grid
Version 10 behavior has been re-instated. |
| 0136628 | Generate XSL publishes language specific pages wrongly.
User Action: Recompile the affected WAM without generating XSL. |
| 0136654 | Blank dates gets changed to 200000 in VL |
| 0136667 | Escape message not issued when file is not there from submit LANSA RUN on RDMLX
User Action: Recompile RDMLX functions that may be called from RDML on System i in batch processing where the batch processor is required to receive notification of fatal errors. |
| 0136689 | YMDX output stamping attribute on VL does not work on UPDATE, only INSERT |
0136720 0137034 | IDE stability
Deleting a file that contains logicals could crash the AutoComplete facility. |
| 0136748 | Deployment tool : Maintain a Host Route Table on a Network Client configuration
The setting for determining the location of a Host Route Table to be used as the basis for an application or package specific Host Route Table has been corrected to look at the Server when running a network client. Previously the local system directory was checked. |
| 0136810 | VL attempts to create temporary files in the root directory
Upgrade of JPEG support introduced a rule that limited memory use to one megabyte causing bigger JPEG files to be managed by a work file. This one megabyte limited has been increased to a gigabyte. |
| 0136816 | SAVE_LIST BIF second argument to be irrelevant for RDMLX code |
| 0136877 | Using tab in Windows forms, fields of type Time do not get focus
A one digit change to a date or time was accidentally cancelled the moment a date/time control loses focus. |
| 0136887 | Visual Style for Grid Cell is lost when UPD_ENTRY is used. |
| 0136902 | WAM would not rebuild correctly after upgrade to SP5 due to code structure
Using a list in a web-map that has the same name as a repository field could cause the mapping to fail. |
| 0136932 | Mixed Mode Commitment with SQL Server 2005 gets SQL Error 3981 |
| 0136948 | Fatal error occurs when loading translations into the translation tool
When attempting to use the Deployment Tool's translation interface, the application crashed after selecting the languages to translate from and to then pressing the OK button. |
| 0136954 | Incorrect behavior of cross reference in DT after setting default options
If the Deployment Tool was configured to include default cross references, when an item was included in a package with no cross reference information selected this selection was being ignored and he default values were applied. |
| 0136981 | RENAME command does not work correctly when using SuperServer
When the Server was not RDML iSeries, RENAME commands correctly would not work when were multiple I/O commands processed.
User Action: If you use SuperServer to RDMLX iSeries, Windows, or UNIX, rebuild any functions that contain RENAME commands. |
| 0137038 | When the list is displayed the values are either missing or corrupted
In Webevent RDMLX functions, columns following columns of integer types (length 2 and 4) will not display. |
| 0137068 | SELECT_SQL Oracle difference between 10.0 and 11.x
Embedded field with a value of blank was stripped to an empty string. When this was compared to a single blank it compared equal on all databases except Oracle. This was due to Oracle interpreting an empty field as a NULL and thus it fails to compare to anything. The fix was to ensure that on Oracle there is at least one blank. |
| 0137102 | When enabled "short char" data type not showing on webevent browse list
If you have enabled the RDMLX partition's "Short Char" option, strings that fall in this category didn't display in webevent browse lists. It would also cause columns following it to not display. |
Affected objects
Windows Components: [Click here to Show table...]
| Object Name | Object Type |
|---|
| liio.dll | \lansa |
| liiosrv.dll | \lansa |
| liis.dll | \lansa |
| liiv.dll | \lansa |
| liiy.dll | \lansa |
| lpcr.bnd | \lansa |
| lpcrfra.bnd | \lansa |
| lpcrjpn.bnd | \lansa |
| x_base.dll | \lansa |
| x_dom.dll | \lansa |
| x_prim.dll | \lansa |
| x_rom.dll | \lansa |
| XSLEditorFrame.dll | \lansa |
| 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 |
| x_bldenv.dat | \x_win95\x_lansa |
| x_filtyp.dat | \x_win95\x_lansa |
| x_txteng.dat | \x_win95\x_lansa |
| x_txtfra.dat | \x_win95\x_lansa |
| x_txtjpn.dat | \x_win95\x_lansa |
| ide.dll | \x_win95\x_lansa\execute |
| lecmd022.dll | \x_win95\x_lansa\execute |
| lecmd037.dll | \x_win95\x_lansa\execute |
| lecmd039.dll | \x_win95\x_lansa\execute |
| lefver04.dll | \x_win95\x_lansa\execute |
| lehfd006.dll | \x_win95\x_lansa\execute |
| lehtfd06.dll | \x_win95\x_lansa\execute |
| lejbs057.dll | \x_win95\x_lansa\execute |
| lejob029.dll | \x_win95\x_lansa\execute |
| lejqm004.dll | \x_win95\x_lansa\execute |
| lesystem.dll | \x_win95\x_lansa\execute |
| letsyeng.dll | \x_win95\x_lansa\execute |
| levfd013.dll | \x_win95\x_lansa\execute |
| levfd072.dll | \x_win95\x_lansa\execute |
| levfd084.dll | \x_win95\x_lansa\execute |
| levfd085.dll | \x_win95\x_lansa\execute |
| lh_hmpkm.dll | \x_win95\x_lansa\execute |
| lh_procb.dll | \x_win95\x_lansa\execute |
| lh_procd.dll | \x_win95\x_lansa\execute |
| lm_sys.dll | \x_win95\x_lansa\execute |
| lm_sysl.dll | \x_win95\x_lansa\execute |
| lm_vis.dll | \x_win95\x_lansa\execute |
| lp_objrp.dll | \x_win95\x_lansa\execute |
| lp_syset.dll | \x_win95\x_lansa\execute |
| lp_systm.dll | \x_win95\x_lansa\execute |
| lp_trhlp.dll | \x_win95\x_lansa\execute |
| lp_trlt.dll | \x_win95\x_lansa\execute |
| lp_trltl.dll | \x_win95\x_lansa\execute |
| lpcr.bnd | \x_win95\x_lansa\execute |
| lpcrfra.bnd | \x_win95\x_lansa\execute |
| lpcrjpn.bnd | \x_win95\x_lansa\execute |
| lxpprbld.exe | \x_win95\x_lansa\execute |
| lxptbbld.exe | \x_win95\x_lansa\execute |
| lxxp0010.dll | \x_win95\x_lansa\execute |
| x_base.dll | \x_win95\x_lansa\execute |
| x_bifms.dll | \x_win95\x_lansa\execute |
| x_comms.dll | \x_win95\x_lansa\execute |
| x_dbmms.dll | \x_win95\x_lansa\execute |
| x_dll.dll | \x_win95\x_lansa\execute |
| x_dom.dll | \x_win95\x_lansa\execute |
| x_funms.dll | \x_win95\x_lansa\execute |
| x_pdfms.dll | \x_win95\x_lansa\execute |
| x_prim.dll | \x_win95\x_lansa\execute |
| x_rom.dll | \x_win95\x_lansa\execute |
| x_run.exe | \x_win95\x_lansa\execute |
| x_ssv.dll | \x_win95\x_lansa\execute |
| ide.chi | \x_win95\x_lansa\execute\eng |
| fun00001.s | \x_win95\x_lansa\source |
| fun00024.s | \x_win95\x_lansa\source |
| iom00001.s | \x_win95\x_lansa\source |
| iom00022.s | \x_win95\x_lansa\source |
| iom00023.s | \x_win95\x_lansa\source |
| trg00001.s | \x_win95\x_lansa\source |
| x_funstr.h | \x_win95\x_lansa\source |
System i Components: [Click here to Show table...]
| Object Name | Object Type | Library |
|---|
| DC@M01(DCM2076 - DCM2077 EIM0139 IOM0200 - IOM0206) | *MSGF | LANSA program library |
| DC@D2015 | *DSPF | LANSA program library |
| DCXS872X | *SRVPGM | LANSA program library |
| DC@S41IL | *SRVPGM | LANSA program library |
| X_BASE | *SRVPGM | LANSA program library |
| X_BIF | *SRVPGM | LANSA program library |
| X_COM | *SRVPGM | LANSA program library |
| X_COMP | *SRVPGM | LANSA program library |
| X_DBG | *SRVPGM | LANSA program library |
| X_DBM | *SRVPGM | LANSA program library |
| X_DLL | *SRVPGM | LANSA program library |
| X_FUN | *SRVPGM | LANSA program library |
| X_PDF | *SRVPGM | LANSA program library |
| X_PRIM | *SRVPGM | LANSA program library |
| X_SSV | *SRVPGM | LANSA program library |
| X_VAR | *SRVPGM | LANSA program library |
| X_RUN | *PGM | LANSA program library |
| lpcr.bnd | STMF | ../x_lansa |
| lpcrfra.bnd | STMF | ../x_lansa |
| lpcrjpn.bnd | STMF | ../x_lansa |
| x_txteng.dat | STMF | ../x_lansa |
| x_txtfra.dat | STMF | ../x_lansa |
| x_txtjpn.dat | STMF | ../x_lansa |
| x_funstr.h | STMF | ../x_lansa/source |
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.
- Sign on with QSECOFR user profile, part of the QSECOFR group or a user profile that has *ALLOBJ and *SECADM special authorities.
- Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_pgmlib/x_lansa) before applying this EPC
- 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.
- End the Listener, Host Monitor and Web Server for the LANSA system and run the LANSA for the Web cleanup program.
- Move the unzipped file EPC837 to an IFS folder on the System i. ( e.g. /LANSA_pgmlib/tmp/epc837' )
- For this EPC use the following options:
- Install the EPC from = *IFS
- Apply this EPC to = FULL_LANSA_SYSTEM
- 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 . . . . . . . . . . . > 837
Install the EPC from . . . . . . > *IFS
IFS Path and object name . . . . e.g. /LANSA_pgmlib/tmp/epc837
Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
LANSA program library . . . . . pgmlib
- 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.
- 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
- Recommend that a backup be done of all LANSA folders and your LANSA database before applying this EPC.
- Stop using the LANSA development environment and stop all currently executing LANSA applications.
- Double-click on EPC837w.exe.
- Select the "Setup" button or "Cancel" if you do not want to proceed.
- If you have multiple configurations installed, Select the configuration to which the EPC is to be applied.
- If you are prompted to reboot your pc - please reboot.
- To view details of the installed EPCs:
- sign into LANSA
- view the Help menu
- Product Information option
- then select the Installation Details tab
- expand the Installation/ EPC Summary
- review the last entries
X_RUN XCMD Parameter Help Text [Click here to Show help...]
5.3.16 XCMD Parameter
XCMD obscures the command line. Y (Yes) or N (No). Microsoft Windows only.
When you include this parameter, the values of a subset of parameters is replaced with asterisks (*) so that viewing the properties of a Windows process using Process Explorer will not show specific parameters.
For example:
C:\PROGRAM FILES\LANSA\X_WIN95\X_LANSA\EXECUTE\X_RUN.EXE PROC=PSLSYS LANG=ENG PART=DEX USER=**** DBUS=*** PSWD=*** DBII=LXDEVPGM DBIT=SQLANYWHERE PRTR=LPT1 DBUG=N ITRO=N ITRM=20000 ITRL=4 ITRC=ALL ITHP=X LOCK=YES XCMD=Y
The parameters for which *** are inserted are: USER, GUSR, DBUS, PSUS, ASUS, PSPW, ASPW.
Note: Passwords (PSWD, PSPW, ASPW) are always obscured, regardless of this parameter's setting.
Default is N.
© 2009 LANSA