export to ‘filename’ of del lobfile ‘filenameoflob’ modified by lobsinfile ‘select….’

heres how to delete the contents of an entire table in DB2 db2 import from /dev/null of del commitcount 1000 replace into ‘tablename’

How to select via date or time in DB2 db2 select * from ‘tablename’ where ‘timestampcolumnname’ > timestamp (‘YYYY-MM-DD-hh.mm.ss.ffffff’)