Meeting Information

Select Meeting  


Meeting Date
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

Click here to Register and Pay using Paypal (Save $$$)

Payment can be made at the door (cash or check only)!



11:30am: CREATE or REPLACE DDS with DDL

Birgitta Hauser
Consultant

Presentation Description

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.
This session will show you how to convert DDS described files into SQL tables and SQL indexes without touching any program code. Birgitta will also be demonstrating how reference files can be used in composition with SQL tables, and how to make table modifications such as adding columns on a specific position or changing data types and lengths.

About Birgitta Hauser

Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as a traditional RPG Programmer but also as a Database and Software Engineer, focusing on IBM i application and database modernization.
Currently she is an independent consultant and works in Consulting, Application Modernization on IBM i and especially Database Modernization on Db2 for i. She also provides individual programming on IBM i to her customers. Additionally, she also works in education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences in Germany, other European Countries, USA and Canada. In addition, she is co-author of two IBM Redbooks and also the author of several articles and papers focusing on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru and IBM DeveloperWorks. In 2015 she received the John Earl Speaker Scholarship Award. In 2018 she received the Al Barsa Memorial Scholarship Award. ? and last not but least she is an IBM Champion since 2020