If you work with Toad for DB2 on your DB2 subsystem, it happens quite often that your work results in a DDL or DML script in the editor. It can’t be executed directly but needs to be scheduled for running in the night. Now you have the challenge to transfer it to your mainframe.
No worries, if you use Toad you can easily transfer your script into a PDS member. Before you can start, please ensure this: On each DB2 for z/OS subsystem on which you want to execute remote scripts via Toad, you must have both the Toad IBM DB2 z/OS component and the SYSPROC.DSNUTILU procedure installed. For information about installing the z/OS component, see the Toad IBM DB2 z/OS Component Installation Guide.
If this is done, simply follow these steps:
A default job-card can be specified under Tools/Options in Toad:
Easily query a PDS on your host: