Using Views to Unlock Your Physical Files

Back to Package

When is comes to modernizing your applications, it can be a very daunting task.  This also include modernizing your data. We know that there are still many physical files out in the wild and converting them to a new DDL based table while can be very freeing, is a huge task. The good news, is using Views, you can start to unlock that data and not have to also modernize that applications that have been using these physical files.  In this iSee, we will look at an automated way to create a set of views over a number of physical files. This will not only give you this automated process, but we then also talk about leveraging these View in new ways. 

Tim Rowe

Business Architect Application Development & Systems Management for IBM i

Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

Scott Forstie

Db2 for i Business Architect

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and Scott is an avid runner and enjoys cooking.


Open to view video.
Open to view video.
SQL Script
Open to download resource.
Open to download resource.