Importing data in DB2

Importing data (including LOBS)

 db2 "import from import_file.txt of DEL LOBS FROM 'c:\folder\where\the\lobs\are\stored\' modified by lobsinfile insert into mytable(field1,field2,field3,...)" 

where:

import_file.txt has the import data row-to-row, comma-separated with strings between double quotes:

123,"abc","xyz_clob.txt",... 

The LOB folder specification MUST end with a path-separator character.