Hello

I want to import picture into table with xml and blob column on same time .. but not succeed..

i have created
create table figure (id int, pic_info XML, pic blob(50k));

and create input.del file
1,'<pic_info>Figure1. xxx</pic_info>' ,pic.gif

and run these command
import from c:\input.del of del lobs from c:\input.del modified by lobsinfile insert into figure;

..but no success
where i'm did wrong

Any help or suggestion will be grateful, thank you.

problem solved

Hi,

would you mind sharing the solution?

Cheers,
nvk

create table figure (id int,pic blob(50k), pic_info XML) ;

1. create the xml file as example "test.xml"

2. create input.del file
1, pic.gif, ＜XDS FIL="test.xml"/＞

3****n
import from c:\input.del of del lobs from c:\input.del modified by lobsinfile insert into figure;

*BTW i put all 3 files(test.xml, input.del, pic.gif) under directory C:/