3.7.12 IOM Required

Specify if an IOM is required for this file and its associated logical views.

The LANSA Repository details for files are included in Input/Output Modules. These modules are called I/O Modules (IOMs), or Object Access Modules (OAMs). IOMs are only used on the IBM i in partitions that are not enabled for RDMLX or where no OAM exists.

If NO (not checked/not selected), you must use the FUNCTION command with the OPTIONS parameter keyword (*DBOPTIMISE) in every RDML function that attempts to access this file/table or any of its associated indexes.

If the FUNCTION command is omitted from the RDML function, it will compile correctly, but will fail at execution time when it places a call to the non-existent OAM.

Default = YES (checked/selected).

Platform Considerations

• IBM i: This table attribute applies to IBM i databases only.

Warning

• Note that if this value is changed from YES (checked/selected) to NO (unchecked/not selected), and the resultant change is made operational, any existing IOM will be automatically deleted. After this has been done, all existing RDML functions that access this table without using *DBOPTIMISE will fail when used. In such cases, add the *DBOPTIMISE option to the RDML functions involved and recompile them.

Tips & Techniques

• Refer to the FUNCTION command in this guide and Using *DBOPTIMIZE / *DBOPTIMIZE_Batch in the LANSA for i User Guide for details of how to set up and use a system without using IOMs.

• It is strongly recommended that you do not use NO (not checked/not selected) until you have had some experience with the LANSA product and are familiar with the concept and workings of IOMs.