Coding in RPG (IBM i/AS400). Using the Truncate SQL statement.

In this video, I'd like to show you an example of how you can remove data from a table in a single operation, using Truncate. Also, if you have a delete trigger assigned to the table, you can remove the data and the trigger will not be executed. Please, let me know what you think about it. Leave your comments below. Don't forget to subscribe! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #sqltraining #as400 #common #modernize #sql #ibmchampion 0:00 Introduction 0:28 Using Run SQL Scripts to show you the table that Im going to play with 1:04 Showing you the table generated using a trigger that is in my table 1:22 Let's delete the data from the table using Truncate 1:54 Executing truncate for checking if there's a trigger in my table. 2:20 Executing truncate for removing data 3:10 Final comments and ending