Features and BenefitsToad® for DB2 z/OS provides:- Greater efficiency when performing daily tasks
- Greater accuracy when writing, debugging and tuning code
- Flexibility to perform many development and administration tasks from a single tool
- A smooth workflow that allows users to move from one task to another easily
- Extensive reporting capabilities that produce quantifiable data and documentation
- Access to DB2 expertise through various Toad user communities
Toad for DB2 z/OS is available in several editions that range from basic querying and reporting functionality, to development and editing, to optimization, and finally advanced administration capabilities.
| Features | Toad Standard | Toad Professional | Toad Xpert | Toad DBA Admin | | Project Manager | X | X | X | X | | SQL Editor | X | X | X | X | | Query Builder | X | X | X | X | | Report Writer and Schema Reports | X | X | X | X | | Formatter | X | X | X | X | | Show or Hide, Sort or Filter or Group Columns in tables | X | X | X | X | | Macro Record | X | X | X | X | | Automation | X | X | X | X | | Difference Viewer | X | X | X | X | | Version Control Integration | X | X | X | X | | ER Diagram | X | X | X | X | | Surround SQL and Convert Embedded SQL into other programming languages i.e. Delphi, C, C++, Java, Pearl and visual basic etc. | X | X | X | X | | Master Detail Browser | X | X | X | X | | Service Manager | X | X | X | X | | HTML Schema Doc Generator | X | X | X | X | | Convert Embedded SQL | X | X | X | X | | Grid Compare | X | X | X | X | | Group Execute | X | X | X | X | | SQL Trace | X | X | X | X | | Toad Security | X | X | X | X | | Website Searching | X | X | X | X | | One Click Export/ Copy and Paste/ Edit Duplicate Data | X | X | X | X | | Import/Export Utility Wizard | X | X | X | X | | External Tools Manager and Connection Manager | X | X | X | X | | Stored Debugger | | X | X | X | | Knowledge Xpert for DB2 z/OS | | X | X | X | | SQL Optimization: Extended EXPLAIN provides plan details and explanations | | | X | | | Context-sensitive SQL tuning advice | | | X | | | Set Tuning Parameters | | | X | | | SQL Comparison for immediate visualizing and performance impact of changes | | | X | | | Advanced Database Administration | | | | X | | Migration | | | | X | | Compare and Synchronize (Schema Objects) | | | | X | | DB2 Advanced Alters | | | | X | | Add on Modules | | SQL Tuning | | | X | | | Other | | Online Help Documentation | X | X | X | X | | World Class Support | X | X | X | X | | Citrix Installation | X | X | X | X | | Unparalleled Beta Program | X | X | X | X |
|