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
Fresche Solutions

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 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.
Birgitta also works in education as a trainer for RPG and SQL developers and is one of the most sought-after speakers at the COMMON User Groups and POWER Conferences in European countries, USA and Canada.
As a co-author of 2 IBM Redbooks and the author of several articles focusing on RPG and SQL for a German publisher and IBM DeveloperWorks, it is no surprise that so many in the IBM i community turn to her for insight.