Attending this event?
Tuesday, April 7 • 12:30pm - 1:45pm
Tips and Tricks for Advanced Embedded SQL

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

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 be written into the IFS and directly read from the IFS. In this session you’ll discover these secrets! How to create, manage and use temporal tables will be demonstrated within this session.

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 12:30pm - 1:45pm
(D) Commons I
Feedback form isn't open yet.

Attendees (2)