Announcement for WMSUG & i-94 User Group meeting
WMSUG will hold a regular meeting on Wednesday May 19th, beginning with a presentation at 8:30AM.
*** Note - Available exclusively via the web ***
"CREATE OR REPLACE … DDS With SQL DDL (Data Definition Language)" by Birgitta Hauser
With the latest releases and technology refreshes the SQL data definition language (DDL) for creating and maintaining database objects was enormously enhanced. DDS on the other hand is stabilized. But still a lot of applications even those with a modern graphical interface and where the latest goodies of the programming language are used in the source code are based on DDS described files. The excuse DDL enhancements cannot be used, because of the DDS description and the native I/O access of these files, does not count any more. With Reverse Engineering, the SQL code for DDS described objects can be retrieved. CREATE OR REPLACE statements allow DDS described physical and logical files to be converted into SQL defined database objects, while the programs that use these files can stay untouched.
Learning Objectives
- Utilize newer IBM i database technologies without rewriting programs
This month's meeting is being held exclusively via the web!
- To receive the webinar connection information for this meeting, join our mailing list.
Click the e-mail me icon and ask our Secretary/Treasurer to add you to our E-mail list. Please call 616-261-6656 if webinar connection problems develop. Presentation access will be sent just previous to meeting day.
About the Presenter:
Birgitta Hauser: Diplom-Betriebswirt (BA), Database and Software Architect
Birgitta 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 traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application and database modernization.
Currently she is self-employed and works in Consulting and Application and Database Modernization on IBM i and Db2 for i and individual programming for customers on IBM i.
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.
She is an IBM Champion 2021
Meeting ends at 10 AM.
Date / Location
Date: Wednesday May 19, 2021
Time: 8:30 AM presentation
Place: *** Note - available exclusively via the web ***
E-mail list for Meeting Notices and Webinar Connection Details:
Click the e-mail me icon and ask our Secretary/Treasurer to add you to our E-mail list.
Membership: The 2020-2021 Season Continues
Review the list of paid memberships. Download and complete the self-service invoice form for your company. Thank you for your support.
If you wish to stop receiving E-mail from WMSUG:
Click on the "e-mail me" icon and specify your changes for our Secretary/Treasurer.
** END of POST **
