Monday, October 21, 2013

Export/Import BlOB data in db2

Posted on 11:24 AM by Kalum Umesh

Export : You need to have directory to unload BLOB data : /ibm/qrep/switch/300813/lobs/
Export command creates a file "clob_test_export.txt" in current directory.

db2 "export to 'clob_test_export.txt' OF DEL LOBS TO '/ibm/qrep/switch/300813/lobs/' LOBFILE my_clob_export MODIFIED BY LOBSINFILE select * from  clob_test"

Import : You need to specify unloaded file and BLOB data location :

db2 "import from clob_test_export.txt of DEL LOBS from '/opt/qrep/switch/300813/lobs/' modified by lobsinfile insert into clob_test" 

No Response to "Export/Import BlOB data in db2"

Leave A Reply

 
Free Website Hosting