Hi all,
how do I export a VARBINARY field in a xml and import it later into
another table?
I have to do that with jdbc.

I think I have to export a VARBINARY filed with getBinary, but how do I
store the result in a xml?
And how do I import it later into the other table? With setBinary? But
I cant store Bytes in a xml, could I?

Is somewhere a sample?

A lot of questions?

Thank you very much...
Stefan

Stefan,

you should provide more precise information:

What is stored in the database? Do you store there XML documents? How
XML fit your requirements?

If you just want to export and import [binary] data you can use DB2
Export/Import API in C and call it from Java.

As I understand, your task is to export data to a file, store multiple
records in XML file, and import it from your program. That kind of
question seems to be more Java related (getBytes, setBytes). To
generate XML from relational tables you can use XMLSERIALIZE,
XMLELEMENT, ... functions.

-- Artur Wronski


Stefan napisal(a):
> Hi all,
> how do I export a VARBINARY field in a xml and import it later into
> another table?
> I have to do that with jdbc.
>
> I think I have to export a VARBINARY filed with getBinary, but how do I
> store the result in a xml?
> And how do I import it later into the other table? With setBinary? But
> I cant store Bytes in a xml, could I?
>
> Is somewhere a sample?
>
> A lot of questions?
>
> Thank you very much...
> Stefan