Athena Framework
Category Archives: 其他技术
DB2获得当前版本Get Version SQL语句
SQL语句: "SELECT service_level, fixpack_num FROM TABLE (sysproc.env_get_inst_info()) as INSTANCEINFO";
通过ALERT为DB2 TABLE增加/删除主键 ADD/DROP PRIMARY KEY
Drop Primary Key 移除主键:
ALTER TABLE TABLE2 DROP PRIMARY KEY
Add Primary Key 增加主键:
ALTER TABLE TABLE2 ADD ID2 INTEGER NOT NULL DEFAULT 1;
ALTER TABLE TA
DB2获得表内主键 Get PrimaryKeys
SQL:
SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR NOT LIKE ‘SYS%’ AND TBNAME = ‘TABLENAME‘ AND KEYSEQ > 0 ORDER BY KEYSEQ ASC;
使用JDBC获取DB2的所有表(getTables)
直接使用metadata.getTables似乎不能获取DB2中指定Database下的所有Table, 但可使用如下语句获取:
"SELECT CREATOR,NAME FROM SYSIBM.SYSTABLES WHERE CREATOR NOT LIKE ‘SYS%&#
