we are evaluating performance, backup and data integrity between:
A) storing actual BLOB images
vs
B) storing path to the images in db2 V9.5 Linux/AIX.
I was able to store actual BLOB images using the load command:
1)
CREATE TABLE "TEST "."IMAGE" (
"IMAGE_NAME" CHAR(15) ,
"IMAGE" BLOB(200 k) NOT LOGGED NOT COMPACT);
2)input_image.del :
TestImage , image_01.tif
3) Load data
load from input_image.del of del
lobs from /test/image/
modified by lobsinfile
insert into test.image;
My question is how do I store the path to BLOB Images using load?
Thanks in advance.