Coding in RPG (IBM i/AS400). Using SENSITIVE and INSENSITIVE cursors. скачать в хорошем качестве

Coding in RPG (IBM i/AS400). Using SENSITIVE and INSENSITIVE cursors.

In this video, I’ll guide you through how sensitivity options work for cursors in embedded SQL on the IBM i — and why understanding SENSITIVE, INSENSITIVE, and ASENSITIVE cursors is essential for writing clean, reliable RPG applications! 🎯 If you’re working with embedded SQL in RPG and want to better control how your programs react to real-time data changes (or you just want to improve your database coding skills), this video is for you. ✅ I'll talk about ... INSENSITIVE cursors (snapshots of data) SENSITIVE cursors (live data that reflects changes) ASENSITIVE cursors (letting the system choose the best strategy) Using cursors with and without SCROLL options Updating rows directly through a cursor using WHERE CURRENT OF Handling data consistency and performance choices ✅ You’ll learn: What each sensitivity option really means (with real-life examples) When to choose SENSITIVE, INSENSITIVE, or ASENSITIVE How sensitivity affects performance and concurrency How to combine sensitivity options with SCROLL cursors Best practices when designing RPG programs that fetch or update database rows 💬 Have you used SENSITIVE or INSENSITIVE cursors in your projects? Share your experience in the comments — I’d love to hear your strategies! 🙌 Enjoy the video — and don’t forget to like & subscribe if you found it helpful! 📌 #IBMi #RPGLE #SQLRPGLE #EmbeddedSQL #RPGProgramming #IBMiDevelopment #AS400 #IBMChampion #Codefori #DB2fori #IBMiTips #COMMON 0:00 Introduction 0:22 What is a Cursor in SQL RPG? 0:50 Explaining INSENSITIVE cursors (snapshot example) 1:44 Explaining SENSITIVE cursors (live update example) 2:58 Talking about ASENSITIVE cursors (system decides) 4:43 Using sensitivity with SCROLL and normal cursors 5:56 Declaring (and filling) tables for examples 7:32 RPG Example: Looping through an INSENSITIVE cursor 11:57 RPG Example: Updating rows through a SENSITIVE cursor 15:10 Final thoughts and wrap-up