General Tips

Page 1 of 1

• Adding shortcuts to the desktop with a Deployment Tool Package
  - Visual LANSA Deployment Tool V12
  How to use After-Install Commands to add your own shortcuts to the Desktop.
• Using Fiddler for Internet troubleshooting
  - LANSA for the Web
  Instructions for attaining Fiddler trace details for troubleshooting.
• Completely clearing out the cache in IE8
  - LANSA for the Web
  Uncheck Preserve Favorites website data option in IE8 to clear the browser cache.
• 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.
• Installing LANSA on a French iSeries via emulation
  - LANSA for iSeries
  Special characters in program library name during French LANSA for iSeries install.

Archive

• Gathering information about LANSA
  - LANSA V10 and V11
  Using the 'About LANSA' feature to generate product information.
• E-mailing an iSeries Spooled File
  - LANSA for iSeries
  How to use Client Access to email Spooled Files.
• Unable to display routing table information
  - LANSA for iSeries
  When attempting to display LANSA Configuration information, it may fail with a message.
• Data Warehousing, LANSAs Practical Solution - Part 1
  - LANSA All Platforms
  Data Warehousing, LANSA's Practical Solution - Part 1
• Data Warehousing, LANSAs Practical Solution - Part 2
  - LANSA All Platforms
  Data Warehousing, LANSA's Practical Solution - Part 2

RDML

• Using database field validations in your LANSA functions
  - LANSA All Platforms
  Existing database field validations can be used in a LANSA function without having to add lots of checks to individual functions.
• Using LANSA fields in SELECT_SQL WHERE parameter
  - LANSA All Platforms
  Existing database field validations can be used in a LANSA function without having to add lots of checks to individual functions.
• LANSA and SQL Tip : Subselect parameter "ANY"
  -LANSA All Platforms
  The "ANY" subselect parameter can be used to execute a sub-selection from another file, before carrying out a requested selection.
• LANSA and SQL Tip : Scalar Built-In functions
  - LANSA All Platforms
  A few handy examples of scalar built-in functions in SQL.
• LANSA and SQL Tip: Scalar built in functions(2)
  - LANSA All Platforms
  A few examples of the scalaire built in functions SUBSTR, CONCAT, MAX and MIN.
• LANSA and SQL Tip : Auto-Join
  - LANSA All Platforms
  SQL can be used to select records from a file based on comparing values of records within the same file.
• Using binary searches on workinglists in LANSA
  - LANSA All Platforms
  Binary searches are a quick method of finding particular values in a workinglist.
• Cascading Updates and Deletes in LANSA
  - LANSA All Platforms
  How to cascade updates and deletes in LANSA using Triggers.
• Converting numbers to alphanumeric strings using a BUILTIN function
  - LANSA All Platforms
  Sometimes negative numbers do not convert successfully to alphanumeric strings. There is a Builtin function available that will solve this.
• Formatting numeric output in LANSA
  - LANSA All Platforms
  Usually when printing cheques the value is printed in words and the amount is formatted either as' $100.80', or '****100.80' instead of '0000100.80'.
• Return Codes for RDML data base access commands
  - LANSA All Platforms
  Return codes for the various LANSA data base access commands.
• Converting Digits to Words in LANSA
  - LANSA for the AS/400 and LANSA for Windows
  Converting a number to into the corresponding word that represents the number.
• Converting an uppercase string so that just the first character in each word is uppercase
  - LANSA All Platforms
  RDML code that will convert a string from all uppercase to just having the first character in each word in uppercase.
• The #PROMPT$FN field
  - LANSA All Platforms
  Multiple fields sharing a common prompt function need to use the #PROMPT$FN field.

Repository

• Function Routing in detail
  - LANSA for the AS/400 and LANSA for Windows
  This tip provides a more detailed view of Function Routing in LANSA and how to use it.
• Creating Portable Programmed Virtual Fields
  - LANSA All Platforms
  Virtual fields in RDML can be created that are then portable to various platforms.
• Validations ARE carried out on Pre-Determined Join Fields
  - LANSA All Platforms
  Validations ARE carried out on Pre-Determined Join Fields.
• Identifying Built-in functions (BIFs)
  - LANSA All Platforms
  It is important that developers are aware of the importance of correctly identifying any BIF.

Communications

• Running the Listener in a dedicated subsystem
  - LANSA for Windows, LANSA Open, LANSA Client, using TCP/IP
  By default, the listener job will run in the subsystems determined by the job description of the user starting the listener. You can, however, create a subsystem to run the listener(s) in.
• Command to create LANSA Listener subsystem
  - LANSA for the AS/400
  Creating the LANSA listener within its own subsystem by creating a user defined command and CL program to create the needed objects.