EMS logo

Products Navigation

Data Import for DB2

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Import for DB2

On-line Documentation


Set correspondence between the target table fields and the source HTML file columns:

  • select a field of the target DB2 table in the New fields list;
  • proceed to the source grid viewer area: click a column to assign the column to the selected target table field;
  • the selected column of the source file gets gray highlight;
  • repeat the operation for all the fields you need to be included in the import process.


If the source file and the destination DB2 table have the same order of columns, you can use the btnAutoFillColumnsXT Auto Fill Columns mode (default) to set correspondence between them automatically. If source file and destination DB2 table have different order of columns but identical names you can use the btnAutoFillColumnsXT Auto Fill by Captions mode to set the correspondence based on name's identity.


The number of the column which correspondence is set for are displayed at the Grid Column column. You can use it for setting the fields correspondence as well.


If new table creation was selected at the previous step, then fields needed for the import procedure will be created automatically.

You can manage destination table fields if needed. Use the corresponded context menu item to Add/Edit/Drop field.




If necessary, you can choose to skip a defined number of the source file rows using the Skip lines spin-edit.


Note: If table was properly created or already exist, it will be marked with a tick Tick. If an error occur during table creation, this table will be marked with a cross .


Step 3 - HTML



To remove all correspondences, press the btnClearAllRanges Clear All Ranges button.


Click the Next button to proceed to the Setting base data formats step of the wizard.