DB2 allows to manually supply temporary work data sets, if prefered not to use SORTDEVT and SORTNUM. In that case, it would be nice if Toad allow to create these files (SORTWK01, SORTWK02, SORTWK03,.....) using the template feature.
Is it possible to to create a template for SORT Work Datasets in DB2?
Enhancement Request TDB-492 is closed because datasets (SORTWK01, SORTWKnn) can not be allocated using DB2 Templates. An attempt to do so will result in an error from DB2.