Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

index information

 
shankar vembu
Ranch Hand
Posts: 309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI,
I am getting the index information for a table using DatabaseMetadata.getindexInfo(). But when I tried to find out whether the index is clustered or not using TYPE, it returns the type as DatabaseMetadata.tableIndexOther even though the index is a clustered index. It has to return DatabaseMetadata.tableIndexClustered. I am using DB2 database and the db2 driver that comes alongwith the database.Is it a problem with the driver? Can anyone clarify this.
regards,
shankar
 
shankar vembu
Ranch Hand
Posts: 309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
is there any way to know whether an index is clustered or not using jdbc???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic