If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > XML importing/exporting V8 UDB

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-21-04, 15:36
young_matthewd young_matthewd is offline
Registered User
 
Join Date: Apr 2004
Posts: 10
XML importing/exporting V8 UDB

Would like to explore importing/exporting data via XML extensions in DB2 V8 in order to simulate import/export utilities.

Essentially we have created Ant Tasks to open JDBC connections to DB2 databases and read ASCII del files partically simulating the import (insert and insert_update operations only) utility. However, parsing of the del files is not as clean as I would like and there is internal convertion of data types done by import that I have faked which is not 100% tested. Basically, I wish IBM provided a JDBC set of classes to perform imports/exports (maybe there exists an API written for JAVA so if anybody knows of one please fire me information). Anyway, the parsing and extra processing of del files isn't exactly extendable to IXF file types. And import simulation transforms insert and insert_update operations into individual insert/update SQL statements. Plus I have no current solution for handeling CLOB or BLOB objects.

What would be nice is if the XML extenders for V8 where mature enough to export/import.

Anybody seen good websites describes a similar process or redbooks or have any spontanious ideas?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On