VARBINARY - BINARY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefan - 01 Jun 2006 08:08 GMT

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

Reply to this Message

Artur - 05 Jun 2006 10:20 GMT

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
[quoted text clipped - 12 lines]
> Thank you very much...
> Stefan

Reply to this Message