SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:13 AM
| ||||
| ||||
 VARBINARY - BINARY 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      |
|
02-27-2008, 07:14 AM
| ||||
| ||||
| Re: VARBINARY - BINARY 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 |
Linear Mode
