How to export db2 table

This is how you export your table in a DB2 Database.

1) First of all make sure you already login as a db2admin or db2 privilege user.

2) Secondly key in -> db2 EXPORT TO file.del of DEL ‘ select * from yourtablename’

3) You’re done. It will export your file into a comma separated value file or known as a CSV format file.

By Zairy


About this entry