UDB Workbench is a development environment for DB2 UDB databases. It includes many features, such as comparing and synchronizing database schemas, packaging schemas and content of DB2 UDB database.

SQL editor in UDB Workbench supports syntax highlighting, SQL formatting, code completion, script execution, and query results support editing, grouping, searching and more.

Here are some key features of "UDB Workbench":

Flexible Connectivity
￭ Support DB2 UDB 6.X/7.X/8.X/9.X
￭ Support loading schema from both file and database

Easy Database Object Manipulation
￭ Support scripting database objects
￭ Support long script execution. If script was executed from the beginning to the end and error has occurred, the statement where the error occurred will be highlighted
￭ Loaded schema will be updated automatically after execution of DDL statements

Powerful SQL Editor
￭ Support syntax highlighting, code completion and tooltip information
￭ Support SQL formatting, include letter case conversion, for example, "TitleCase", "camelCase", etc.
￭ Support line revision marks, split view, full screen edit, drag-and-drop edit, column mode edit, code folding, multiple levels of undo and redo, Unicode and DOS/UNIX/MAC formatted files

Convenient Query Tool
￭ Allow editing, grouping, searching, filtering and sorting
￭ Table and record views to see data the way you like it
￭ Query results can be exported to Excel spreadsheet or as a set of SQL statements

Integrated "Diff" Tool for Database Comparison as well as Data Comparison
￭ Color-coded side-by-side comparison makes it easy to pinpoint at a glance
￭ Allow edit and synchronize data comparison results

Generate Synchronization Script for Database Schema Synchronization
￭ User will be alerted when synchronization script contains any warnings, such as, data truncation, incompatible data type conversion, etc.
￭ Permit user to review and manually update synchronization script prior to executing it

Other Useful Features
￭ Convenient to view information on dependencies between database objects
￭ Generate script to recover invalid database objects, recovering objects include inoperative views, inoperative triggers and incorrect NEXTVAL of identity columns
￭ Generate script to export data, import data, load data, REORG tables and RUNSTATS tables

Requirements:

· Pentium or compatible processor
· DB2 UDB ODBC driver
· A PDF viewer

Limitations:

· 14 days trial

What's New in This Release: [ read full changelog ]

· Enhanced grid performance and some minor bug fixes