DB2 9.7 对分区表进行全文本搜索
2010-02-04 00:00:00 来源:WEB开发网
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.
- ››db2 对float类型取char后显示科学计数法
- ››DB2中出现SQL1032N错误现象时的解决办法
- ››DB2 锁升级示例
- ››db2诊断系列之---定位锁等待问题
- ››db2 命令选项解释
- ››DB2 最佳实践: 使用 DB2 pureXML 管理 XML 数据的...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 基础: 表空间和缓冲池
- ››DB2 XML 编程,第 1 部分: 理解 XML 数据模型
- ››DB2 pureScale 实战
更多精彩
赞助商链接