DB2 Export to CSV

$ db2 "CONNECT TO DBNAME USER APPCORE"

$ db2 "SET SCHEMA APPCORE"

$ db2 "EXPORT TO M_USERS-HEADER.csv OF DEL MODIFIED BY NOCHARDEL SELECT SUBSTR(REPLACE(REPLACE(XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME c, '\"' || COLNAME || '\"') ORDER BY COLNO) AS CLOB), '<C>', '; '), '</C>', ''), 3) FROM SYSCAT.COLUMNS WHERE TABSCHEMA = 'APPCORE' AND TABNAME = 'M_USERS' "

$ db2 "EXPORT TO M_USERS-BODY.csv OF DEL MODIFIED BY NOCHARDEL COLDEL; SELECT * FROM M_USERS "

$ cat M_USERS-HEADER.csv M_USERS-BODY.csv > M_USERS.csv

$ rm -rf M_USERS-HEADER.csv M_USERS-BODY.csv

$ db2 "TERMINATE"

 

Source :

https://stackoverflow.com/questions/51100182/export-results-from-db2-to-csv-including-column-names-via-bash