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"
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"
Subscribe to:
Post Comments (Atom)
No Response to "Export/Import BlOB data in db2"
Leave A Reply