DB2 - Import csv file into db2 table - Load Data From File

Truncate the Table.

db2 "truncate analysis_LoadData IMMEDIATE" Connect to Database db2 connect to MDM user db2inst using password awk '{print $1","$1","$1}' UpdateList.txt > list2BeLoaded.txt

Input File - list2BeLoaded.txt 

Target Table - analysis_LoadData db2 import from list2BeLoaded.txt of del insert into analysis_LoadData or db2 load ---which is faster then db2 import