31

SELECT substr(replace(CHAR('2012-12-24'),'-',''),1,6) FROM sysibm.dual;   -- yyyymm


-- 表改名
RENAME TABLE  emp  TO emp_1;
-- 索引改名
RENAME INDEX NEW-IND TO IND


-- EXCEL 导入DB2
1.另存为csv格式，
2.运行-》DB2cmd->connect to gis user db2_zbn using huawei
a.
import   from   "D:\流量层次.csv"   OF   DEL   messages   "d:\msg.out"     INSERT   INTO  GIS.TB_FLW_LEVEL_CODE_TEST

b.
import from  'D:\手机品牌.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_PHONE_BRAND
import from  'D:\手机型号.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_PHONE_MODEL
import from  'D:\终端品牌.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_TERML_BRAND
import from  'D:\终端型号.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_TERML_MODEL

SELECT EMPNO, COALESCE(SALARY, 0) FROM EMPLOYEE

SELECT EMPNO, nvl(SALARY, 0) FROM EMPLOYEE

20130305导入数据

import from  'D:\流量层次表.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_FLW_LEVEL_CODE

import from  'D:\业务图层数据.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_NET_LAYER_INFO_M

import from  'D:\异常流量分析.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_WARNFLW_USER_INFO_M
import from  'D:\分流效果评估.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.TB_GOFLW_EFF_EVLUT_M
import from  'D:\分流效果评估.xls' OF DEL modified BY coldel0x09 commitcount 1000  INSERT   INTO  GIS.RPT_GOFLW_EFF

CREATE FUNCTION GET_CHAR (ii_num DOUBLE)
   RETURNS VARCHAR (100)
   SPECIFIC GET_CHAR
   LANGUAGE SQL
   BEGIN ATOMIC
      DECLARE oi_return   VARCHAR (100) DEFAULT NULL;

      IF (ii_num >= 1)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12961536/viewspace-1061388/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12961536/viewspace-1061388/