LANSA and 3rd Party Software Tips

Page 1 of 1

LANSA for iSeries

• Important/Common System i Queries and Commands
  - System i and LANSA
  The following article, in which the most commonly required/used System i queries and commands are collated, should be useful to anyone trying to collect system i control information.
• Copying a physical file to a save file
  - OS/400
  FTP'ing a save file to an iSeries and forgetting to create the save file first - steps to copy a physical file to a save file.

LANSA for the Web

• PTF requirements for LANSA for the Web (including WAMs)
  - LANSA for the Web
  LANSA for the Web and iSeries software and PTF requirements.
• Applying SP2 to WinXP has an effect on how web sites display in the browser
  - LANSA for the Web
  Web sites, both non-LANSA for the Web and LANSA for the Web, have the potential to not display correctly in the browser after applying Service Pack 2 (SP2).

Visual LANSA

• Planned Support of Windows Server 2008 R2 by LANSA
  - All LANSA Products
  LANSA support for Windows Server 2008 R2
• Planned support of Windows 7 by LANSA
  - ALL LANSA Products
  LANSA support for Windows 7
• LANSA and SQL Server - Configuration Options
  - Visual LANSA V11 SP5 and above
  After investigating numerous Database options with Microsoft, three key areas of SQL Server concerning enterprise level I/O were defined.
• Guide to configuring an Oracle database for a LANSA installation
  - Visual LANSA V11 SP5 or later
  A guide to the configuration of an Oracle database for use by a Visual LANSA installation (either development or production).
• Visio 2007 support in LANSA
  - Visual LANSA 11.3 and above
  Can Visio 2007 be used with the LANSA logical Modeler in V11.3.
• PTFs required for correct maths calculations when using RDMLX on iSeries
  - Visual LANSA
  Incorrect precision calculations when using RDMLX on iSeries fixed via PTF.
• Using Visual LANSA Framework RAD-PAD on Windows Vista requires a Microsoft Active-X component DHTMLEdit
  - Visual LANSA Framework
  You may experience problems using RAD-PADs on Vista as it requires a Microsoft Active X control which can be added in manually.
• Oracle 10g ODBC driver recommended for Visual LANSA
  - Visual LANSA
  Oracle V10g ODBC driver recommended for use with Visual LANSA.
• Support of Microsoft Vista by LANSA
  - All LANSA Products
  LANSA support for Microsoft Vista
• How to access ASA 9.0.2 documentation
  - Visual LANSA V11
  ASA 9.0.2 is shipped in V11 without documentation but can be downloaded.
• Information when creating the first table in a partition in Oracle
  - Visual LANSA
  When creating the first table in a partition, you must be a user with the same rights as the LANSA_SCHEMA_CREATOR role.
• Blocked connections with your SQL Server implementation
  - Visual LANSA
  Important note before progressing with your SQL Server implimentation.

Archive

LANSA for the Web

• Configuring IBM HTTP server using CGI
  - LANSA for the Web
  Detailed instructions for configuring IBM HTTP Server (using CGI) for use with LANSA for the Web.

Visual LANSA

• Oracle V9iR2 ODBC driver recommended for Visual LANSA V10.0
  - Visual LANSA V9.1 and V10.0
  Oracle V9iR2 ODBC recommended for use with Visual LANSA V10.0.
• Intermittent server licensing failure
  - Visual LANSA
  Intermittent server licensing failure.
• Sign on failure when connecting from a Client in SuperServer mode to a MS SQL
  - Visual LANSA
  Sign on failure when connecting from a Client in SuperServer mode to a MS SQL Server database using a domain user.
• The difference between a DATA SOURCE (when using ODBC) and a DATA BASE (when using MS/Access directly) can cause confusion
  - Visual LANSA
  he difference between a DATA SOURCE (when using ODBC) and a DATA BASE (when using MS/Access directly) can cause confusion.
• Host Monitor fails to start. Error message LII0028S
  - Visual LANSA
  Error message LII0028S 'Failed to start the Host Monitor at the Host. Aborting LANSA for Windows Host Monitor.'
• It is possible to increase the performance of the database
  - Visual LANSA
  It is possible to increase the performance of a SQL/Anywhere database by increasing the cache memory available to it.
• Operating System Error 13 (Permission denied) in UNIX
  - Visual LANSA
  This error code indicates that the current user did not have permission to access an operating system file.
• Modifying compile and link options for performance on Linux
  - Visual LANSA
  Modifying compile and link options for performance, etc.
• To avoid database connection issues, ensure that all parts of the install use the same login
  - Visual LANSA
  Modifying compile and link options for performance, etc.
• Maximum precision for decimal numbers must be set to at least 30
  - Visual LANSA
  If the maximum precision for decimal numbers is not set to 30 or more, the first symptom will be that the LANSA database will not be constructed properly.
• Installation of EPCs, EPCs in the X_BOOT directory
  - Visual LANSA
  Installation of EPCs, EPCs in the X_BOOT directory.
• Cursor not visible and/or numeric fields not displayed correctly
  - Visual LANSA
  Cursor not visible and/or numeric fields not displayed correctly in input fields.
• Message: Record with this key already exists
  - Visual LANSA
  Record with this key already exists.
• Configuring SQL Anywhere for use with LANSA/Server and LANSA/SuperServer
  - Visual LANSA
  Configuring SQL Anywhere for use with LANSA/Server and LANSA/SuperServer.