WEB开发网
开发学院数据库DB2 DB2 9.7 对分区表进行全文本搜索 阅读

DB2 9.7 对分区表进行全文本搜索

 2010-02-04 00:00:00 来源:WEB开发网   
核心提示: db2text"updateindexpart.multiindfortext"CTE0001Operationcompletedsuccessfully.db2"select*frompart.multipartwherecontains(comment,'

  
 db2text "update index part.multiind for text" 
 CTE0001 Operation completed successfully. 
 db2 "select * from part.multipart where contains(comment, '\"blue\"')=1" 
    
 PK YEAR VALUE COMMENT 
    
 ----------- ----------- ----------- ------------ 
 1 2001 1 blue and grey 
 
 6 2001 1 new blue and grey 
    
 8 2002 1 new red checkered with blue 
    
    
 3 record(s) selected. 
    
 db2 "select * from part.multipart where contains(comment, '\"new\"')=1" 
    
 PK YEAR VALUE COMMENT 
    
 ----------- ----------- ----------- ------------ 
 6 2001 1 new blue and grey 
 7 2001 1 new yellow or red 
 
 8 2002 1 new red checkered with blue 
 
 3 record(s) selected. 
    
 db2 "select * from part.multipart where contains(comment, '\"update\"')=1" 
    
 PK YEAR VALUE COMMENT 
 ----------- ----------- ----------- ------------ 
 5 2003 1 update grey or green 
 
 
 1 record(s) selected. 
  
    
//查询主日志表和辅助日志表: 
 
 db2 "select * from DB2EXT.TLOGIX322707" 
    
 OPERATION TIME PK01 
 ----------- ----------- ----------- 
    
 0 record(s) selected. 
    
 db2 "select * from SYSIBMTS.SYSTSAUXLOG_IX322707" 
    
 PK GLOBALTRANSID GLOBALTRANSTIME OPERATIONTYPE 
 ----------- ----------- --------- ------------- 
    
 0 record(s) selected. 

上一页  4 5 6 7 8 9 10  下一页

Tags:DB 分区表 进行

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接