POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Tuesday, May 21 • 8:00am - 9:00am
31AL Open Access Magic! Restructure Your Database Without Modifying Applications

Log in to save this to your schedule, view media, leave feedback and see who's attending!

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:

  1. Enabling a transformation of your Database model while keeping your current application working.
  2. Benefit of normalization of your DB

avatar for Pascal Polverini

Pascal Polverini

Solutions Strategist, Fresche Solutions
Pascal Polverini has a strong experience in end-to-end software architectures, with expertise on DB, programming languages, communication protocols and GUI.Co-author of the IBM i Modernization Redbook, he is an expert in cross technologies.Active member of the IBM i ISV Advisory Council... Read More →

Tuesday May 21, 2019 8:00am - 9:00am PDT
Fantasy Tower North Ballroom A
  • Level Beginner
  • Operating System IBM i
  • Audience Developers, IT managers and CEOs would benefit from this session