Anthony Etzel / Tuesday, July 9, 2019 / Categories: Infor LX & BPCS Tips Infor LX & BPCS Tip of the Week: LX 8.4 Database The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance. Previous Article Crossroads RMC is Proud to Announce Product Certification for Baan IV to Avalara! Next Article A/P Payment Update in LX 8.3.4 Print 64790 Rate this article: 5.0 Contact Anthony EtzelAnthony Etzel Other posts by Anthony Etzel Contact author Facebook page Twitter Linked In YouTube Website Contact author Message sent. Name: Please enter your name. Please enter your name. Email: Please enter a valid email address. Please enter a valid email address. Please enter your email. Subject: Please enter a subject Please enter a subject Company: Please enter company name. City: Please enter City name. Region: Please enter Region name. Country: Please enter Country name. Telephone: Please enter telephone. Mobile: Please enter mobile number. Message: Please enter the message. Please solve captcha Please solve captcha. Close x
21Jan2020 Crossroads RMC Tip of the Week: How to Prevent Your Company From Being a Victim of Ransomware Tuesday, January 21, 2020 Read more
10Feb2026 Infor LN & Baan Tips & Tricks for EXECUTIVES Tuesday, February 10, 2026 Read more FINANCE: Copy Received Purchase Invoices (tfacp1210m000) OPERATIONS: Production Order Parameters TECHNOLOGY: Audit Configuration Management Read more