THEN
SET oi_return =
trim (
'.' FROM trim (
'0' FROM trim (
CHAR (
CAST (
ii_num AS DECIMAL (30, 5))))));
ELSEIF (ii_num=0 OR ii_num is NULL ) THEN
SET oi_return='0.00';
ELSE
SET oi_return =
'0'
|| trim (
'0' FROM trim (CHAR (CAST (ii_num AS DECIMAL (30, 5)))));
END IF;
RETURN oi_return;
END;
import from 'D:\基站小区维表.xls' OF DEL modified BY coldel0x09 commitcount 1000 INSERT INTO GIS.TB_COMTY_CODE
卸载DB2
开始运行-db2unins /f
-- 手机号码
'13'||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
SET oi_return =
trim (
'.' FROM trim (
'0' FROM trim (
CHAR (
CAST (
ii_num AS DECIMAL (30, 5))))));
ELSEIF (ii_num=0 OR ii_num is NULL ) THEN
SET oi_return='0.00';
ELSE
SET oi_return =
'0'
|| trim (
'0' FROM trim (CHAR (CAST (ii_num AS DECIMAL (30, 5)))));
END IF;
RETURN oi_return;
END;
import from 'D:\基站小区维表.xls' OF DEL modified BY coldel0x09 commitcount 1000 INSERT INTO GIS.TB_COMTY_CODE
卸载DB2
开始运行-db2unins /f
-- 手机号码
'13'||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
||TRIM(CHAR(INT(rand()*9)))
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-1061389/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
