General Tips

Reset
DateVersionTip 
Mar 21, 2014LANSA Open for .NETA LANSA Open for .NET license error can be generated if all installation steps are not completed
When setting up LANSA Open for .NET there is an import for each platform that must be completed to avoid execution issues
 
Jul 02, 2011Visual LANSA Deployment Tool V12Adding shortcuts to the desktop with a Deployment Tool Package
How to use After-Install Commands to add your own shortcuts to the Desktop
 
Dec 11, 2009LANSA for the WebUsing Fiddler for Internet troubleshooting
Instructions for attaining Fiddler trace details for troubleshooting
 
Dec 11, 2009LANSA for the WebCompletely clearing out the cache in IE8
Uncheck Preserve Favorites website data option in IE8 to clear the browser cache
 
Sep 05, 2005Visual LANSA V11How to access ASA 9.0.2 documentation
ASA 9.0.2 is shipped in V11 without documentation but can be downloaded
 
Jul 28, 2005LANSA for iSeriesInstalling LANSA on a French iSeries via emulation
Special characters in program library name during French LANSA for iSeries install
 
Aug 4, 2003LANSA for iSeriesE-mailing an iSeries Spooled File
How to use Client Access to email Spooled Files
 
Apr 14, 2003LANSA for iSeriesUnable to display routing table information
When attempting to display LANSA Configuration information, it may fail with a message
 
ArchivedLANSA V10 and V11Gathering information about LANSA
Using the 'About LANSA' feature to generate product information
 
ArchivedAll PlatformsData Warehousing, LANSAs Practical Solution - Part 1
Data Warehousing, LANSA's Practical Solution - Part 1
 
ArchivedAll PlatformsData Warehousing, LANSAs Practical Solution - Part 2 Data Warehousing, LANSA's Practical Solution - Part 2  
ArchivedAll PlatformsUsing database field validations in your LANSA functions
Existing database field validations can be used in a LANSA function without having to add lots of checks to individual functions
 
ArchivedAll PlatformsUsing LANSA fields in SELECT_SQL WHERE parameter Existing database field validations can be used in a LANSA function without having to add lots of checks to individual functions  
ArchivedAll PlatformsLANSA and SQL Tip : Subselect parameter "ANY"
The "ANY" subselect parameter can be used to execute a sub-selection from another file, before carrying out a requested selection
 
ArchivedAll PlatformsLANSA and SQL Tip : Scalar Built-In functions
A few handy examples of scalar built-in functions in SQL
 
ArchivedAll PlatformsLANSA and SQL Tip: Scalar built in functions(2)
A few examples of the scalaire built in functions SUBSTR, CONCAT, MAX and MIN
 
ArchivedAll PlatformsLANSA and SQL Tip : Auto-Join
SQL can be used to select records from a file based on comparing values of records within the same file
 
ArchivedAll PlatformsUsing binary searches on workinglists in LANSA
Binary searches are a quick method of finding particular values in a workinglist
 
ArchivedAll PlatformsCascading Updates and Deletes in LANSA
How to cascade updates and deletes in LANSA using Triggers
 
ArchivedAll PlatformsConverting numbers to alphanumeric strings using a BUILTIN function
Sometimes negative numbers do not convert successfully to alphanumeric strings. There is a Builtin function available that will solve this
 
ArchivedAll PlatformsFormatting numeric output in LANSA
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'
 
ArchivedAll PlatformsReturn Codes for RDML data base access commands
Return codes for the various LANSA data base access commands
 
ArchivedLANSA for iSeries &
Visual LANSA
Converting Digits to Words in LANSA
Converting a number to into the corresponding word that represents the number
 
ArchivedAll PlatformsConverting an uppercase string so that just the first character in each word is uppercase
RDML code that will convert a string from all uppercase to just having the first character in each word in uppercase
 
ArchivedAll PlatformsThe #PROMPT$FN field
Multiple fields sharing a common prompt function need to use the #PROMPT$FN field
 
ArchivedLANSA for iSeries &
Visual LANSA
Function Routing in detail
This tip provides a more detailed view of Function Routing in LANSA and how to use it
 
ArchivedAll PlatformsCreating Portable Programmed Virtual Fields
Virtual fields in RDML can be created that are then portable to various platforms
 
ArchivedAll PlatformsValidations ARE carried out on Pre-Determined Join Fields
Validations ARE carried out on Pre-Determined Join Fields
 
ArchivedAll PlatformsIdentifying Built-in functions (BIFs)
It is important that developers are aware of the importance of correctly identifying any BIF
 
ArchivedVisual LANSA, LANSA Open,
LANSA Client
Running the Listener in a dedicated subsystem
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
 
ArchivedLANSA for iSeriesCommand to create LANSA Listener subsystem
Creating the LANSA listener within its own subsystem by creating a user defined command and CL program to create the needed objects