How to automatically truncate tables with Toad for DB2

This is Jeff Podlasek with Toad DB2 development. I'm going to demonstrate some features that we've added to our Toad DB2 version 5.0 release. I've got Toad up and running now and I've got a couple database browsers open. The first one is connected to DB2 z/OS subsystem. I've got the tables tab open. And what I'm going to do now is select multiple tables, right click, and select utilities, truncate tables. So in this new 5.0 release, we now allow you to very quickly and very easily generate truncate tables command. And of course just like our other utility and command generation screens, you could very quickly and very easily specify the options you want to use. Select show script and generate and execute the truncate table commands. And the same holds true for DB2 LUW. This database browser is connected to a DB2 LUW database. I'm on the tables tab, I'm going to select multiple tables, right-click, and save utilities truncate tables. And again this brings up the truncate tables command. You could very easily generate the truncate table statements for LUW. Another thing we've changed for DB2 LUW is on the utilities set integrity screen. The screen existed in our previous release, but now we've added a new command option. This command option is called single commands. If you leave it false and generate the script, it's going to generate one set integrity command for all the tables that you've selected. If you wanted to change that to true, then we will go back to the old fashioned way of generating individual set integrity statements for each table.