DB2 Export and Import Data

Here are the steps on how to export and import data from and to database in the delimited (.del) format.

1. Export:

2. Import

Note: if a table structure includes fields set as GENERATED ALWAYS or IDENTITY, then the below commands would do the work.

 

If a fieldĀ  in the table structure is defined as IDENTITY, then you’d need to override the IDENTITY with the command below:

If a field is in the table structure is defined as GENERATED ALWAYS then you’d need to override auto generated values with the command below:

Please Note: Every single time the LOAD command is used, you’d need to run the following command:

 

 

Leave a Reply