Wednesday, April 14, 2020
at the Remote, room
in Westbury, Long Island
The Presession starts at 5pm
The Networking and Cocktail hour starts at 6pm
We continue to see enhancements to the SQL Data Definition Language (DDL) with every new release of IBM i. These improvements facilitate creating and maintaining critical database objects. DDS on the other hand is stabilized. Yet we may find that many of our business applications still use DDS described files. We tend to use the excuse that DDL enhancements will not work with DDS described files. However, with reverse engineering, the SQL code for DDS described objects can be retrieved! CREATE OR REPLACE statements allow DDS described files to be converted into SQL defined database objects, while leaving programs that use these files untouched. With the CREATE OR REPLACE TABLE statement, we can manage files with fields based on field reference tables.
Birgitta Hauser has worked on the IBM i and contributed to the community for more than 25 years, earning the title of IBM Champion in 2020. She is currently working for Fresche Solutions Inc., focusing on application and database modernization.