This is Jeff Podlasek with Toad DB2 development. Let me demonstrate the new index key expression support, that we've added into Toad DB2 version 5.0, specifically for DB2 z/OS version 9. I've got Toad up and running, I've got a database browser open, I've selected a tables tab, and what I am going to do is create an index on this account IDs table. I'll right click, say create index, and the Create Index screen comes up. I'm going to give it an index name. It's called IX. And now you'll notice some new buttons that we have on the right hand side here. So if I want to add a key expression, I could just type one in. So basically what I'm doing is going to have an index that's going to be the equivalent of two integer values of my table. Click OK.
If I wanted to add another column to that index, I could just use these buttons over here to move that over. And if I wanted to add another expression, I could just bringing one up. So for example, I'm going to add a left on the ACCT. So it used the five most left bytes of the account name column here, as well. Now I'm to click Show Script then generate this. And as this thing runs it's going to create the index. So it's actually executing the SQL right now. The index is created. I'm going to go to the Dependencies tab, and we'll be able to see that index that just got created. And then what I'm going to do now is just right click on that index, send it to Object Details, so we can see the details of that index. And you can see that index indeed has a couple of expressions and has a single column value in it as well.
02:08