新商盟省级站数据整理步骤说明：数据导出导入有多种方法，多种工具。本示例提供一种基本方法，仅供参考。数据导入导入客户信息表EC_CUST创建临时表CREATETABLEDB2inst2.EC_CUST_TMP(ORG_CODEVARCHAR(15),CUST_CODEVARCHAR(30),CUST_NAMEVARCHAR(128),SHORT_CODEVARCHAR(16),SHORT_NAMEVARCHAR(64),LICENSE_CODEVARCHAR(16),LICENSE_DATECHARACTER(8),MANAGERVARCHAR(16),CUST_TELVARCHAR(16),ORDER_TELVARCHAR(16),BUSI_ADDRVARCHAR(128),PERIODSVARCHAR(8),PRD_ST_DATEVARCHAR(8),ARR_DAYINTEGER,BANK_NAMEVARCHAR(32),ACCOUNTVARCHAR(32),CUST_LMT_TYPEVARCHAR(8),PAY_TYPEVARCHAR(8),RTL_CUST_TYPEVARCHAR(20),CUST_GEO_TYPEVARCHAR(4),CUST_SIZEVARCHAR(2),SALE_CENTER_CODEVARCHAR(15),SALE_CENTER_NAMEVARCHAR(64),SALE_DEPT_CODEVARCHAR(15),SALE_DEPT_NAMEVARCHAR(64),SLSMAN_CODEVARCHAR(16),SLSMAN_NAMEVARCHAR(32),SLSMAN_TELVARCHAR(16),SLSMAN_MOBILEVARCHAR(16),WHSE_CODEVARCHAR(32),ORDER_WAYCHARACTER(2),STATUSCHARACTER(2),ORDER_END_TIMEVARCHAR(8))INUSERSPACE1;--删除原有数据Deletefromec_cust_tmp;--替换excel表枚举值，另存为csv格式--导入临时表importfromc:\EC_CUST_TMP.csvofdelinsertintoEC_CUST_TMP;--去除空格UPDATEEC_CUST_TMPSETORG_CODE=LTRIM(RTRIM(ORG_CODE)),CUST_CODE=LTRIM(RTRIM(CUST_CODE)),CUST_NAME=LTRIM(RTRIM(CUST_NAME)),SHORT_CODE=LTRIM(RTRIM(SHORT_CODE)),SHORT_NAME=LTRIM(RTRIM(SHORT_NAME)),LICENSE_CODE=LTRIM(RTRIM(LICENSE_CODE)),LICENSE_DATE=LTRIM(RTRIM(LICENSE_DATE)),MANAGER=LTRIM(RTRIM(MANAGER)),CUST_TEL=LTRIM(RTRIM(CUST_TEL)),ORDER_TEL=LTRIM(RTRIM(ORDER_TEL)),BUSI_ADDR=LTRIM(RTRIM(BUSI_ADDR)),PERIODS=LTRIM(RTRIM(PERIODS)),PRD_ST_DATE=LTRIM(RTRIM(PRD_ST_DATE)),BANK_NAME=LTRIM(RTRIM(BANK_NAME)),ACCOUNT=LTRIM(RTRIM(ACCOUNT)),CUST_LMT_TYPE=LTRIM(RTRIM(CUST_LMT_TYPE)),PAY_TYPE=LTRIM(RTRIM(PAY_TYPE)),SALE_CENTER_CODE=LTRIM(RTRIM(SALE_CENTER_CODE)),SALE_CENTER_NAME=LTRIM(RTRIM(SALE_CENTER_NAME)),SALE_DEPT_CODE=LTRIM(RTRIM(SALE_DEPT_CODE)),SALE_DEPT_NAME=LTRIM(RTRIM(SALE_DEPT_NAME)),SLSMAN_CODE=LTRIM(RTRIM(SLSMAN_CODE)),SLSMAN_NAME=LTRIM(RTRIM(SLSMAN_NAME)),SLSMAN_MOBILE=LTRIM(RTRIM(SLSMAN_MOBILE)),WHSE_CODE=LTRIM(RTRIM(WHSE_CODE)),ORDER_WAY=LTRIM(RTRIM(ORDER_WAY)),ST