Loading…
Attending this event?
Tuesday, April 7 • 10:30am - 11:45am
SQL – Queries – Do you know what you can do with a simple SELECT-Statement?

Sign up or log in to save this to your schedule and see who's attending!

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. Currently SQL provides around 180 scalar functions and 30 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. All kinds of sub- and grand totals can be built. Recursive Common Table Expressions and hierarchical query clauses allow recursive data (such as bill of materials or flight plans) to be analyzed. Since release 7.2 TR 1 regular expressions can be used. Release 7.3 offers a new range of OLAP-Functions … In this workshop you will learn multiple ways for solving your requirements by using a single SQL Select Statement.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Tuesday April 7, 2020 10:30am - 11:45am
(D) Commons I
Feedback form isn't open yet.

Attendees (1)