The database is the foundation of any application. It’s the last tier you’ll remove, and the first tier you’ll want to extend or transform. Modernizing your database from DDS to DDL is part of the transformation, but there’s also real value in changing the structure of your entire database – normalizing it, splitting or merging tables, changing field type or length, etc. A modernized structure is key to helping you meet evolving business needs. Historically, structural database changes were possible only with significant modification of your RPG applications. In fact, you almost had to re-write your applications to map to the new database structure. Well, not anymore. In this session, you’ll be introduced to a new and unique solution that lets you restructure your database without having to modify your IBM i applications. Our innovative use of Open Access leaves RPG applications as-is during database restructuring, and also provides an OA API for COBOL applications. Going forward, you’ll be able to optimize your SQL engine, use real date fields or Unicode, extend fields to varchar, integer or Boolean, remove redundancies, normalize your database (1,2,3NF+) … all without having to modify your current applications! Any changes will be assimilated by your existing code. The time and effort that you will save are impressive.
Learning Objectives:
- Enabling a transformation of your Database model while keeping your current application working.
- Benefit of normalization of your DB