var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to Store the path to BLOB Images in DB2 V9.5 LUW?
we are evaluating performance, backup and data integrity between:
A) storing actual BLOB images
B) storing path to the images in db2 V9.5 Linux/AIX.
I was able to store actual BLOB images using the load command:
CREATE TABLE "TEST "."IMAGE" (
"IMAGE_NAME" CHAR(15) ,
"IMAGE" BLOB(200 k) NOT LOGGED NOT COMPACT);
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.