LANSA for iSeries Tips

Page 1 of 2

• Finding and Working with Spool Files Generated under a QPRTJOB Job | LANSA for iSeries
  - LANSA for iSeries All Versions
  How to find the full attributes of a Spool file for a most recently produced Spool file in a job
• High Availability/Mirroring with LANSA on IBM i
  - LANSA for iSeries V11 & V12
  Some suggestions on how to set up High Availability (Mirroring) on IBM i for LANSA
• LANSA and V7R1
  - LANSA for iSeries
  LANSA for iSeries - supported versions
• Temporary files created in the folder X_LANSA on the IFS can take up significant space
  - LANSA for iSeries & LANSA for the Web
  Temporary files created in the folder X_LANSA on the IFS are not deleted and can take up significant space.
• Cleaning up old system variable evaluation programs
  - LANSA for iSeries V11.3
  Old versions of system variable evaluation programs can interfere with your current system.
• Commonly used system control information
  - LANSA on System i
  The following article provides a clear roadmap to assist in obtaining the system control information most commonly requested by 3rd party vendors for licensing purposes.
• Listing of objects created by LANSA when compiling on the iSeries
  - LANSA for iSeries V11
  This document lists the type of objects created by LANSA when compiled on the iSeries.
• How to modify BLOB fields on the iSeries to be greater than 10MB
  - LANSA for iSeries V11
  In Version 11 when working with BLOBs you may encounter messages indicating that there is a limit of 10MB.
• Listener fails with error MCH6801 - Object domain or storage protection error
  - LANSA for iSeries
  When trying to start the LANSA Listener, the Listener fails and error message MCH6801 - Object domain or storage protection error for offset &5 in object &1 appears in the job log.
• Details of support for IBM i 6.1
  - LANSA for iSeries
  Customers wishing to use LANSA with IBM i 6.1 should use LANSA V11.5 or later.
• Extended instructions for applying a LANSA EPC to iSeries
  - LANSA for iSeries
  This page contains extended instructions for moving an EPC to the iSeries.
• Get CCSID and other attributes related to the current Job
  - LANSA for iSeries
  An approach to retrieve your iSeries Job related attributes
• How to view the contents of the 2 LANSA iSeries V11.3 CDs
  - LANSA for iSeries V11.3
  LANSA iSeries CD contents.
• LANSA and V5R4
  - LANSA for iSeries
  LANSA support for V5R4
• RDML OTHER file - allow long field names with a length greater than 256 characters
  - LANSA for iSeries
  LANSA for the iSeries (RDML) is capable of handling fields greater than 256 characters which also have long field names in OTHER files loaded into LANSA.
• Performing upgrade of LANSA for iSeries causes objects to not be restored depending on system value QALWOBJRST
  - LANSA for iSeries
  Errors upgrading LANSA for iSeries if system value QALWOBJRST has been set not to allow restore of objects that adopt authority.
• Do you need to recompile LANSA for iSeries programs when field level validation has changed?
  - LANSA for iSeries
  When you make a file definition change in LANSA there is a series of considerations to cover.
• How to Call a LANSA Function from a 3GL
  - LANSA for iSeries
  How to call a LANSA function from a C program (3GL) in LANSA for Windows and LANSA for iSeries.

Page 2 of 2

• Calling a C Function with arguments from LANSA
  - LANSA for iSeries
  This is a simple example of calling a C program from a LANSA RDML function.
• How can I improve the performance of a function that reads specific records from a large file?
  - LANSA for iSeries
  A simple function to select specific records from a large file (48,000,000 records) is taking on average 1 hour and 10 minutes to execute in batch.
• How can I use the MAIL_ADD_ATTACHMENT BIF in LANSA for the iSeries?
  - LANSA for iSeries V9.1 and up
  Format of the Attachment Path when using the MAIL_ADD_ATTACHMENT Built-in Function in LANSA for the iSeries.
• How to find out which TP jobs relate to a given user
  - LANSA for iSeries
  Easy way to quickly find which job belongs to particular users.
• How do I break a field out into multiple fields based on type with LANSA?
  - LANSA for iSeries
  How do I break a field out into multiple fields based on type? In RPG I would use a data structure. How do I do this in LANSA?
• Batch import of HTML - All parameters are necessary
  - LANSA for iSeries & LANSA for the Web
  How to submit a batch import of HTML.
• 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.
• How does iSeries check authority
  - LANSA for iSeries
  The sequence of authority checking used by the iSeries.
• How to use PERMFILOVR
  - LANSA for iSeries
  Iinformation and examples on how to use LANSA's Permanent File Overrides facility.
• Allowing IE to browse the IFS like it was a normal Windows folder
  - LANSA on System i
  What you need to do in your iSeries TCP configuration so that IE5.5+ can directly access the IFS like it was a windows folder.
• Imports issue where QCCSID value is not a valid default value for QLANGID
  - LANSA for iSeries
  For LANSA import jobs which either default to or are run under job CCSID (Coded Character Set Identifier) 65535, the data may be converted and then displayed incorrectly.
• Large e-mail attachments are not received properly when using the LANSA email Integration BIFs
  - LANSA for iSeries
  Large email attachments are not received properly, corrupting and splitting the e-mail message. There is POP attribute that needs to be changed to avoid this situation.
• New System Variable *VISUAL_LANSA
  - Visual LANSA and LANSA for iSeries
  A new system variable called *VISUAL_LANSA has been introduced to distinguish between program execution on LANSA for iSeries and Visual LANSA.
• Allow fields greater than 256 characters
  - LANSA for the AS/400
  This approach can be applied for fields up to 9999 characters long and even for any non-supported data types.

Archive

• The 6th option for Configure task tracking
  - LANSA for iSeries V10
  Once EPC703 has been applied, you will now have an extra option in the Configure task tracking in System Partition Definition screen.
• Enhancement in EPC721 to allow new Content Types also allows embedding Images in “text/html” Email Content
  - LANSA for the Web V10 EPC721
  Images can now be embedded in an email after applying EPC721 to LANSA for the Web V10.
• Archived - How do I create a LANSA save file for use with an earlier OS400 version?
  - LANSA for iSeries
  Cannot use or display LANSA-generated save files that are created on an earlier OS version.
• Archived - *DBMS_RECORD_LOCKED must be used only if there was an I/O error
  - LANSA for the AS/400
  The *DBMS_RECORD_LOCKED variable is used to detect if the previous I/O operation (e.g. SELECT or FETCH) failed because the record was locked during the allowable wait time.
• AS/400 TCP/IP ports
  - LANSA for the Web
  Some LANSA for Web connection problems may be related to the inappropriate use of TCP/IP Ports.
• The meaning of the Task ID states
  - LANSA/AD
  Task Ids can have 4 states. This is a summary of the meaning of these states
• Large number of fields in a file affect performance
  - LANSA for the AS/400
  he number of fields in a file can affect application performance but only if very large numbers are involved.
• About LANSAs Multilingual support
  - LANSA for Windows and LANSA for the AS/400
  Changing partition multilingual attributes.
• Using "Optimize for Remote Communications"
  - LANSA for the AS/400
  Functions compiled on a process with the "Optimize for Remote Communications" flag set to 'Y' can cause unexpected results.
• File Security consideration under LANSA
  - LANSA for the AS/400
  File Security considerations under LANSA Authority and Ownership.
• Object Authority handling under LANSA
  - LANSA for AS/400
  LANSA uses adopted authority to handle access to OS/400 objects both defined by LANSA and outside of LANSA.
• Unlock parameter listener job
  - LANSA for the AS/400
  To minimize the dependency of the Listener Job on the LANSA system from which it is started, use the optional parameter PARM01(*UNLOCK).
• Using Variable Length Fields in LANSA
  - LANSA for the AS/400
  LANSA allows the use of Variable Length fields using these steps.
• Null-capable field support in LANSA
  - LANSA for the AS/400
  LANSA for the AS/400 is capable of handling Null-capable fields containing null values for both input and output in externally described database files (i.e OTHER files).
• 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.
• EPC Logging on your AS/400
  - LANSA for the AS/400
  The DC@FEP file will contain details of which EPCs have been added to the LANSA system.
• An expansion on the Group Job/Attention Key theme
  - LANSA for the AS/400
  This example provides a flexible way of using the attention program facility by making the command executed VARIABLE.
• Bulk load of OTHER files
  - LANSA for the AS/400
  New optional facility allows the definitions of a number of OTHER files to be made known to LANSA.
• Making multiple AS/400 files known to LANSA automatically
  - LANSA for the AS/400
  A handy tool to import multiple non-LANSA files into the LANSA Repository.
• Making multiple AS/400 files known to LANSA automatically
  - LANSA for the AS/400
  A handy tool to import multiple non-LANSA files into the LANSA Repository.
• User defined RDML Built-in function
  - LANSA for the AS/400
  It is possible to write user defined built in functions via a LANSA function instead of via a 3GL program.
• Positioning in a file using the SELECT command
  - LANSA for the AS/400
  Using the number of keys parameter of the SELECT command instead of *STARTKEY WHERE( ) and defining work fields to save the values of the key fields.
• Dynamic help text maintenance
  - LANSA for the AS/400
  UPDATE or ADD Help Text to fields within an application whilst the application was running.
  
• The effect of using triggers to evaluate virtual fields
  - LANSA for iSeries and LANSA Open
  A SELECT with a WHERE condition is evaluated slightly differently on LANSA for iSeries and LANSA Open (and LANSA Client).
• Seat based licences
  - LANSA for iSeries
  How do the seat based licences like Dnn work, what is checked, how many sessions are available, how many log on's are permitted?
• When and what do I re-compile?
  - LANSA for iSeries
  When and what do I re-compile?
• Impact analysis example
  - LANSA for the AS/400 V7.5
  Display all functions which have been exported since a date.
• Joining files using OPNQRYF
  - LANSA for the AS/400
  An example of how to join files using OPNQRYF.
• Avoid recursive calls in LANSA functions when using ATTN-key
  - LANSA for the AS/400
  LANSA ATTN program for LANSA.
• Warning about Fetch fields
  - LANSA for the AS/400
  Be careful when using parameters *ALL, *ALL_REAL and *ALL_VIRT - only use them when necessary.
• Converting an S/36 DIRECT file into a LANSA file
  - LANSA for the AS/400
  Steps to convert an S/36 DIRECT file into a LANSA file.
• Printing in A4 format in LANSA for the AS/400
  - LANSA for the AS/400
  A printed document might not have A4 format although the printer file has A4 format in its definition.
• The Developer Services facility
  - LANSA for the AS/400
  How can "Developer Services" be used to facilitate communications during testing between developers and testers?
• Formatting output in LANSA
  - LANSA for the AS/400
  Sometimes, after creating all necessary logical files when writing an application on the AS/400, a "special" requirement arises for some other more specific or generic searching requirement.
• Using multilingual definitions in multilingual environments
  - LANSA for the AS/400
  Multilingual definitions for a particular language should be typed in using a display device and keyboard descriptions set for that language.
• Accessing remote files from LANSA using DDM
  - LANSA for the AS/400
  Accessing remote files from LANSA using the OS/400 Distributed Data Management (DDM) facility.
• Column heading width on screens and reports in multilingual partitions
  - LANSA for the AS/400 and LANSA for Windows
  When adding a field to the screen or a report, the column headings are wider than necessary. This could be caused by the column heading widths in other languages.
• Using Hex colors to give LANSA fields color
  - LANSA for the AS/400
  It is possible in LANSA for the AS/400 to use hex codes to give the value of fields specific colors.
• Using missing parameters on the LANSA SUBMIT command
  - LANSA/AD Release 6.5 or later
  The LANSA SUBMIT command does not have all the possible parameters that the AS/400 CL command SBMJOB has. However, all the possible extra parameters can be defined via a special User Exit Program.
• Using 10 character filenames
  - LANSA for the AS/400
  The permanent file override facility gives the ability to use files that are not standard LANSA file names.
• Writing your own User Defined Built-in Functions
  - LANSA for the AS/400
  In an RDML function standard supplied built-in functions (BIF's) can be used to manipulate dates, numeric and character strings, etc. BIF's can also be written by the user.
• Finding the length of a string in LANSA
  - LANSA for the AS/400 and LANSA for Windows
  A couple of different ways to find out how many characters there are in a string.
• What is Function Routing in LANSA?
  - LANSA for the AS/400 and LANSA for Windows
  Function Routing allows the automatically (re)routing of invocations of a function to another function at execution time without changing a program.
• Conditioning the execution of virtual code
  - LANSA for the AS/400 and LANSA for Windows
  Conditioning the execution of virtual code based on whether a field has been requested in a LANSA I/O command. This can improve the execution of an I/O module.
• Easy way to find out your LANSA/AD release and PC level
  - LANSA for the AS/400
  This program provides an easy way to to find out which release and PC level you have for LANSA for the AS/400.
• Using PANEL_IDs to help remote problem solving in LANSA code
  - LANSA for the AS/400
  What are those funny numbers that appear in the top left hand corner of screens in LANSA Applications?
• Reducing the size of LANSA applications
  - LANSA for the AS/400
  Functions compiled with observability and debug are much bigger than those compiled with these compile settings turned off.
• Automating mass compilations in LANSA
  - LANSA for the AS/400
  Mass Compilation Example: Compiling I/O modules with observability intact, when moving from CISC to RISC.
• Suggested tips for improving an application's performance
  - LANSA for the AS/400
  Tips for improving application performance.
• Creating Help Text using MS-WORD and transferring it into LANSA/AD
  - LANSA for the AS/400
  It is possible to create help text using MS-WORD and then transfer this help text into LANSA for the AS/400 on the AS/400.
• Advanced Function Printing (AFP)
  - LANSA for the AS/400
  Advanced Function Printing (AFP)
• New Keywords on DC@OSVEROP data area
  - LANSA for the AS/400
  There are several new keywords on the DC@OSVEROP data area.