Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    33

    Unanswered: import lob and xml on sametime

    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.

  2. #2
    Join Date
    Oct 2010
    Posts
    33
    problem solved

  3. #3
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    would you mind sharing the solution?

    Cheers,
    nvk

  4. #4
    Join Date
    Oct 2010
    Posts
    33
    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:/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •