Summary

Lessons learned

By completing this tutorial, you learned about the following concepts and tasks:

• The basics of working with databases in EGL with statements such as get and add
• Ways to write your own SQL statements, including in explicit SQL, in the SQL builder, in the default selection condition for SQLRecord parts, in prepared statements, and with the execute statement
• How to work with more complex data by performing table joins
• Host variables in explicit SQL and in prepared statements
• How to handle errors in data access applications