EMS Data Import for DB2 is a versatile software that enables easy import of data to DB2 from various sources, including MS Excel, Access, DBF, XML, TXT, CSV, Word, RTF, ODF, and HTML files. The tool comes with customizable import parameters to ensure efficient and simplified data migration.
The tool comes with several adjustable import parameters, including source data formats for all fields and the destination data formats chosen by the user. The software also allows users to skip specific records and select commit options, making the import process highly customizable.
Data Import for DB2 includes a wizard that allows users to visually set their DB2 import options for various files. The command-line utility is available to help execute one-touch imports to the DB2 database.
Users can import data to a single or multiple tables or views from different databases by setting up the features and import parameters correctly. Some of the adjustable import parameters include the source file, the number of records to skip, and the different import modes available - Insert All, Insert New, Insert or Update, and others.
Other fantastic features of the EMS Data Import for DB2 software include automatic creation of table structures, command-line utility to import data using the configuration file and powerful visual options module. Additionally, users can save all import parameters set on the current wizard session, making it more convenient to manage data imports.
In summary, if you're in search of reliable software that simplifies the process of data imports for DB2 tables, then look no further than EMS Data Import for DB2.
Version 3.3:
Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
Other improvements and bugfixes.
Version 3.1:
-Importing data from the text of XML documents embedded nodes
-Ability to explicitly specify the data file for the console version using the -datafile= parameter
-Auto-recognition of columns and autofill of table fields for TXT files
-Other minor improvements and bugfixes.
Version 3.0:
- The new “Native†method of import is added which includes two algorithms – Single Commands and Batch Insert.
- Import from new formats.
- Utility source code significantly optimized, work speed increased.
- Other improvements and bugfixes.
Version 3.1:
-Importing data from the text of XML documents embedded nodes
-Ability to explicitly specify the data file for the console version using the -datafile= parameter
-Auto-recognition of columns and autofill of table fields for TXT files
-Other minor improvements and bugfixes.
Version 3.0:
- The new “Native†method of import is added which includes two algorithms – Single Commands and Batch Insert.
- Import from new formats.
- Utility source code significantly optimized, work speed increased.
- Other improvements and bugfixes.
Version 2.1: - Added Portuguese language support, decreased processor loading while executing long operations and more...