Friday, September 18 • 9:00am - 12:00pm

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

SQL is IBM's relational database language that can be used to query, update and delete data from the database. SQL is becoming the 'de facto' industry standard for accessing distributed data. Record Level Access on the other side can only be used with RPG and Cobol. However instead of using embedded SQL in the same way as native I/O, it makes more sense to join multiple tables or views, merge different sub-selects and even aggregate data in a single SQL-statement (Set based thinking). SQL also provides a lot of scalar functions that are not available in RPG, but with embedded SQL they can be directly used, without accessing any table. 

But there is even more: 
·         Result Sets returned by stored procedures can be consumed 
·         Data can be read from and directly written to the IFS. 
·         And web-services can be accessed and consumed. 
In this workshop you’ll discover how all these features can be used directly in RPG.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
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... Read More →

Friday September 18, 2020 9:00am - 12:00pm CDT
Application Development Room 2
  Database, Application Development
  • Audience Intermediate
  • Learning Objective In this workshop you will learn how to embed and execute SQL commands from within an HLL respectively RPG. you’ll learn some tricks are not widely known to make embedded SQL more convenient.