Welcome to the Online Session Guide for the COMMON 2016 Annual Meeting and Exposition. Using this tool, you can access information regarding the sessions offered, build a custom schedule, print off handouts, and participate in session evaluations. We look forward to seeing you in New Orleans!
View analytic
Sunday, May 15 • 12:45pm - 2:00pm
14AM 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. Using embedded SQL in the same way as native I/O may already make life easier, but there is much more that can be done with embedded SQL. In this way it is possible to use SQL scalar functions without accessing a table (physical file) or view. With a single fetch a block of rows can be read. Case clauses allow you to make static SQL statements almost dynamic. Beginning with Release 7.1 result sets returned by stored procedures can be directly consumed with (embedded) SQL. IFS files (such as XML documents) can be stored as large objects within SQL tables. But how to create and/or access those documents within your embedded SQL programs? In this session you’ll discover these secrets!

Learning Objectives:

  • 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

This is session 570221

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Engineer, Toolmaker Advanced Efficiency GmbH
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →

Sunday May 15, 2016 12:45pm - 2:00pm
Grand Salon 15&18 | First Floor
  • Session Content Level Advanced
  • Operating System IBMi
  • 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.

Twitter Feed