$ db2 "IMPORT FROM TBL_X.csv OF DEL MODIFIED BY DELPRIORITYCHAR DATEFORMAT=\"yyyy-mm-dd\" TIMEFORMAT=\"hh.mm.ss\" TIMESTAMPFORMAT=\"yyyy-mm-dd-hh.mm.ss.uuuuuu\" COLDEL; SKIPCOUNT 1 INSERT INTO TBL_X"
Source :
https://stackoverflow.com/questions/49771080/how-to-skip-the-header-row-in-csv-file-while-loading-data-in-db2
https://stackoverflow.com/questions/20855959/import-from-file-having-line-breaks
Comments
Post a Comment