| Message: 45218 |
 |
BY: Alex Pitigoi (alexp)
DATE: 2008-02-24 20:47
SUBJECT: RE: Schema Dumper Fails because of XML index Hi Phil,
First, you should probably open a bug to track this issue more effectively, but let me provide also some details that might give a bit more insight:
1. The 4 possible types of data retrieved by the driver through IBM_DB::statistics are the following (see driver API), and I am yet to confirm which would help with XML index:
http://rubyibm.rubyforge.org/docs/driver/0.9.0/rdoc/classes/IBM_DB.html#M000019
* Return value:: Parameter type
* 0 (SQL_TABLE_STAT):: The row contains statistics about the table itself.
* 1 (SQL_INDEX_CLUSTERED):: The row contains information about a clustered index.
* 2 (SQL_INDEX_HASH):: The row contains information about a hashed index.
* 3 (SQL_INDEX_OTHER):: The row contains information about a type of index that is neither clustered nor hashed.
2. We might be able to override what's needed in the IndexDefinition if we can find enough details of the spec (as we had done with TableDefinition in order to support XML)
We'll keep you posted with our investigation in this regards.
Thanks for those details provided,
Alex
| |
Start New Thread
Schema Dumper Fails because of XML index