Stumbled on this very nice easy way to export to a delimited file from the DB2 Command Line Prompt (CLI) today.
db2 “EXPORT TO <filename> OF DEL MODIFIED BY NOCHARDEL <select statement>”
i.e.
db2 “EXPORT TO result.csv OF DEL MODIFIED BY NOCHARDEL select * from empinst.employee”