EMS Data Export for DB2 is a powerful program to export your data quickly from DB2 databases to any of 19 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others. Data Export for DB2 includes a wizard, which allows you to set export options for each table visually (destination filename, exported fields, data formats, and much more) and a command line utility to export data from tables and queries in one-touch.
Exporting data to 19 most popular formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, ODF, SYLK, DIF, LaTeX, SQL, Clipboard and others
Exporting data from several tables, views or queries at the same time
Selecting fields to export and changing their order
Adjustable parameters for each exported table and specific parameters for each output format
Saving all export parameters set on current wizard session to the configuration file
Command-line utility to automate your export jobs using the configuration file
Latest DB2 version support
User-friendly wizard interface
300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
64 MB RAM or more; 128 MB or more recommended
20MB of available HD space for program installation
Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
Microsoft Mouse or compatible pointing device
DB2 Run-Time/Administrative Client 8.0 or higher
DB2 for Linux, UNIX and Windows
What’s new in Data Export version 3.0:
Unicode support. Now you are able to export Unicode data (from SQL Server, MySQL and PostgreSQL databases).
Export to new formats is available now:
>>MS Excel 2007
>>MS Word 2007
>>Open Document Format (Open Document Text and Open Document Spreadsheet)
>>Generic XML with XSD schema
Now you can use parameters in data export queries. The parameters are prompted in interactive mode in the wizard. In the Console version query parameters can be set in the command line or prompted in interactive mode.
Utility source code significantly optimized, work speed increased.
Now you can select destination server (SQL Server, Oracle, MySQL, DB2, etc.) when exporting to SQL format. Result script will be generated in accordance with the specifications of the target server.
Wizard window is now resizable.
An error used to occur when exporting tables containing VARCHAR fields with the length of more than 255 symbols to MS Access. Fixed now.
Other minor improvements and bugfixes.