Loading…
POWERUp 2020 has ended
Join your friends and colleagues in the COMMON community at POWERUp 2020. In the company of peers and over 100 industry experts, you’ll enjoy the best in Power Systems and IBM i education over the course of 4 days. View the list of nearly 400 sessions, which cover over 20 areas of IT. POWERUp also boasts the largest exposition of its kind. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?
Back To Schedule
Tuesday, September 1 • 8:00am - 9:00am
Advanced Embedded SQL

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
While native I/O can only be used with programming languages such as RPG and COBOL, (embedded) SQL can, or even must, be used by other programming languages. The main goal of embedded SQL is accessing and modifying data in SQL tables. 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). The result can be either processed sequentially or with a single block fetch read into an array data structure. SQL scalar functions can be used directly in embedded SQL without accessing any table or view. Beginning with Release 7.1 result sets returned by stored procedures can be directly consumed with (embedded) SQL. All kinds of documents (for example XML documents and text files) as well as audio and video files can be stored in the IFS or inserted as large objects into SQL tables. With embedded SQL those files cannot only be copied, but also written into the IFS and directly read from the IFS. In this session you’ll discover these secrets!
In this session you’ll learn some tricks are not widely known to make embedded SQL more convenient. This session will also show in examples how to consume result sets with embedded SQL and how to read and write IFS files with embedded SQL.
Speakers
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 →

Tuesday September 1, 2020 8:00am - 9:00am EDT
Learning Center
  Application Development
  • FOCUSED EDUCATION ROADMAP SQL Programming
  • LEVEL Advanced
  • AWARD BRONZE
  • AUDIENCE Developers who already use embedded SQL and would like to exploit advanced SQL technologies, such as consuming result sets or accessing IFS files within their embedded SQL programs.

Attendees (19)