Want to export data from DB2 table to SQL file for upserting?
Using DB2ToTxt, you can export data from DB2 table to sql file for upserting easily and fast, just a few mouse clicks!
Export data from DB2 table to SQL file for upserting
Click “Export From Table” at task dialog.
then show the Export Single Table form.
1. Select SQL file type.
2. Select table.
3. Enter data file name.
Set “Convert Mode” to “Upsert”, enter “Update Key”.