BEGIN:VCALENDAR VERSION:2.0 PRODID:-//jEvents 2.0 for Joomla//EN CALSCALE:GREGORIAN METHOD:PUBLISH BEGIN:VTIMEZONE TZID:America/Los_Angeles X-LIC-LOCATION:America/Los_Angeles BEGIN:DAYLIGHT TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT DTSTART:19700308T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST DTSTART:19701101T020000 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:17d77de19d72a29580e1964c6c7e80e2122 CATEGORIES:Events SUMMARY:2023 April 29 - Take Your SQL Skills to the Next Level - In-Person Workshop with Birgitta Hauser DESCRIPTION:
SELECT excitement, fun, education
FROM oc ean_user_group
8:30 am - Check in & Continental Breakfast
9:00 am - Group by, Having and Multi-Dime nsional Grouping - Break - SQL Services fo r the ILE Programmer
12:30 pm - SQL and IFS – Reading/Writing IFS files with SQL - Break span> - Boolean – The New Da ta Type in SQL
3:00 pm - Workshop Ends
Event Location: Vang uard University, 55 Fair Dr., Costa Mesa, CA 92626 p>
Event Fee: OCEAN Mem bers $50, Non-Members $100
Please contact us at info@oceanusergroup.org if you would still like to attend!
Group by, Having and Multi-Dimensi onal Grouping An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate fun ctions allows one to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP B Y clause may be widely known and used, but the HAVING clause which goes han d in hand with the GROUP BY is often a mystery. There may be other secrets waiting to be revealed … or did you know you can create all kinds of sub-to tals and grand-total with an SQL GROUP BY?
<
span style="font-family: arial, helvetica, sans-serif; font-size: 16px; col
or: #000080;">SQL and IFS – Reading/Writing IFS files with SQL SQL is great for accessing data located in a relational database. But
in a modern world it is also necessary to consume data that is located in t
he IFS (Integrated File System) or provided by web services. With each Tech
nology Refresh IBM introduces and enhances Db2 for i Services. With Release
7.4 Technology Refresh 3 IBM provides new SQL Stored Procedures for readin
g data from and writing Data into the IFS. In composition with other SQL F
unctions, it is easy to scan through IFS files or decompose *.csv files or
JSON files or XML documents located in the IFS.
Boolean – The New Data Type in SQL In this session you will learn not on ly how to define columns in tables and views, but also how to convert data in a character or numeric data type into BOOLEAN. But what if we have to de al with this data type in programming languages such as RPG?..
Birgitta Hauser has worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started program ming on the AS/400 in 1992. She worked and works as a traditional RPG Progr ammer but also as aDatabase and Software Engineer, focusing on IBM i appl ication and database modernization.
Currently she is an independent consultant and works in Co
nsulting, IBM i Application Modernization and especially Datab
ase Modernization on Db2 for i. She also provides individual programming on
IBM i to her customers. Additionally, she also works in education as a tra
iner 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 focusi
ng on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru a
nd IBM DeveloperWorks.In 2015 she received the John Earl Speaker Scholarshi
p Award. In 2018 she received the Al Barsa Memorial Scholarship Award. IBM
Champion 2021.