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

Coding in RPG (IBM i/AS400). Using Table Partitioning.

In this video, I explore how to use Table Partitioning in SQL on IBM i (using DB2 for i) to improve performance when working with large tables! 🚀 If you’re struggling with huge tables, slow queries, or heavy maintenance tasks, this video is for you. I’ll show you how to define RANGE and HASH partitions, how to query specific partitions, and even how to work with them from SQL RPG programs. ✅ You’ll learn: How partitioning works on IBM i The difference between RANGE and HASH partitioning How to modify partitions How to create partitioned or global indexes Tips for using partitions in RPG Partitioning can optimize your queries and make your database more manageable — especially with millions of records! 💬 Do you have other tips or best practices for partitioning on IBM i? Share them in the comments! I'd love to hear how you’re using this feature. Enjoy! #IBMi #IBM #RPGLE #RPG #SQLRPGLE #RPGProgramming #IBMiDevelopment #AS400 #Codefori #DB2forI #VSCode #COMMON #ibmchampion 0:00 Introduction 0:29 Talking about benefits of partitioning. 1:20 Creating a table for the example. 2:34 Adding some example records to the table. 3:08 Partitioning method one. "RANGE". 3:45 Adding partitioning to the definition of the table. 6:26 Partitioning method two. "HASH". 7:05 Adding partitioning to the definition of the table. 7:48 Talking about using partitioned tables with native RPG. 8:14 Accessing to the different partitions instead of accessing to the table. 8:30 Altering a created table, adding or modifying partitions. 11:47 Creating indexes on partitioned tables. 13:54 Talking about partitioning: an example of use. 15:00 Creating an ALIAS for accessing to a partition. 16:45 Using partitioning from an SQL RPGLE program. An example. 20:21 Final thoughts and wrap-up