Skip to content

Instantly share code, notes, and snippets.

@soapplied

soapplied/gist:5899230

Last active December 9, 2016 16:28
Show Gist options
  • Save soapplied/5899230 to your computer and use it in GitHub Desktop.
Save soapplied/5899230 to your computer and use it in GitHub Desktop.
Download ZIP
DB2 export DB tables
Raw
gistfile1.sql
db2 connect to MYDB
db2 -x "select tabname from syscat.tables where TABSCHEMA='MYSCHEMA'
and type='T'" > tableNames
while read TABLE; do
db2 EXPORT TO ./exported/$TABLE.del OF DEL lobs to ./exported/lobs
lobfile $TABLE xml to ./exported/xml xmlfile $TABLE
modified by lobsinsepfiles xmlinsepfiles MESSAGES ./exported/$TABLE.txt
"SELECT * FROM MYSCHEMA.$TABLE"
done < tableNames
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment