DB2获得当前版本Get Version SQL语句

Categories: Database; Tagged with: DB2 • SQL; @ October 3rd, 2010 18:12

SQL语句: "SELECT service_level, fixpack_num FROM TABLE (sysproc.env_get_inst_info()) as INSTANCEINFO";

运行结果:

+———————+——————+
| SERVICE_LEVEL     | FIXPACK_NUM |
+———————+——————+
> DB2 v9.7.200.358   | 2                              |
+———————+——————+

See: http://bytes.com/topic/db2/answers/443690-how-get-current-db2-version-v8-higher

通过ALERT为DB2 TABLE增加/删除主键 ADD/DROP PRIMARY KEY <-> 字符串连续空格处理 – 在线小工具(使用Flex与正则表达式创建)

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects