在SQL中使用ADMIN_CMD运行DB2的AdminCommand (Like JDBC Run ReOrg)

Categories: Database; Tagged with: ADMIN_CMD • DB2 • ReOrg; @ October 3rd, 2010 22:36

在使用JDBC时, 除了运行SQL语句之外, 可通过存储过程ADMIN_CMD运行Administrator Command.

譬如, 你无法通过SQL要求DB2进行ReOrg, 但有了ADMIN_CMD, 可通过以下代码运行:

statement.execute("CALL ADMIN_CMD('REORG TABLE TABLE2')"); // Run ReOrg through JDBC

 

See: http://it.toolbox.com/blogs/db2luw/call-administration-commands-through-sql-admin_cmd-7395

字符串连续空格处理 – 在线小工具(使用Flex与正则表达式创建) <-> DB2: TRUNCATE TABLE 清空表内容 SQL语句

---

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