About the Webinar
Our Lunch and Learn session – SQL Beyond Basics: Exploring Advanced Techniques on IBM i, will explore advanced SQL techniques to retrieve data from APIs and systems, optimizing overall IBM i development processes.
Advanced Structured Query Language (SQL) techniques include using catalog views/tables, procedures, and functions to retrieve information about databases. These techniques help developers to optimize data retrieval, enhance query performance, and simplify complex data operations.
In this session, we will uncover the applicable advanced SQL techniques and how they can be used appropriately to improve the efficiency, scalability, and maintainability of IBM i development projects.
Key Takeaways
- Creating SQL tables using System Catalog views/tables.
- Developing procedures and functions for retrieving system information using SQL instead of CL commands
- Using SQL statements to read and write data from and to IFS files, treating them like regular database tables.
- Retrieving the journal entry or related information using SQL catalog tables
- Uncovering additional SQL cursor features
