Search code examples
importdb2db2-luw

How to skip the header row in CSV file while loading data in DB2


Its a very big CSV file so am not able to open and edit the first row. I need to load the data without the first row.


Solution

  • This worked for me

    db2 'import from EMP_SAMPLE.csv of del skipcount 1 INSERT INTO EMP_DET (FIRST_NME, SECOND_NME)'