Did you know you can do this with SQL?! |
|
Today SQL is not only used for ad-hoc queries, but replaces more and more native I/O and must be used in composition with all programming languages other than RPG and COBOL. Moving business logic into data base is one of the main goals when we talk about application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement which may be much more powerful than you can imagine. In this way I want to show you several more, less or even unknown functions and features and demonstrate how, to use them. For example formatting numeric values, determining the first Monday in a month, accessing IFS files and web-services … and more. Bio: 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 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. 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. Since 2020 she is an IBM Champion. Members please RSVP to receive a link to the remote presentation on Thursday, May 13th 1PM CT. Mit freundlichen Grüßen / Best regards Thanks, and stay healthy. The Gateway/400 Board |
|
********************************************************************************* Gateway/400 meetings -- FREE to members -- -- $25 for extra attendees from member companies -- -- $40 for non-members -- For membership application, click here |
Copyright © 2021