Monday, July 1, 2013

DB2 - Export database contents

Script for export all DB2 database tables data - useful for fast search and comparison

In case there is a need to search or compare database contents (without knowing at the beginning in which table to search for - such that to use sql statement(s)) then you could export database tables data in delimiter file format as well as export  all LOB and XML data. The script below illustrates this scenario.

No comments:

Post a Comment