注册

-6803: 非法的参数数据

Shines 2024/11/08 514 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:麒麟操作系统
【CPU】:
【问题描述】*:-6803: 非法的参数数据

insert into "tem_cq_yzjc"."yzjc_yezhu_info"
SELECT
-- ID
RowGuid AS id,
-- 创建人
OperateUserGuid AS create_by,
-- 创建时间
OperateDate AS create_time,
-- 修改人
OperateUserGuid AS update_by,
-- 修时间
OperateDate AS update_time,
-- 备注
NULL AS description,
-- 姓名
yzname AS yzname,
-- 身份证
idnum AS idnum,
-- 手机号
lxdh AS mobile,
-- openid
openid AS openid,
-- 别名
nikename AS nikename,
-- 头像地址
avatar AS avatar,
-- 渝快政的userid
NULL AS userid,
-- 证件类型 IFNULL(idnum,NULL,'1')
CASE WHEN idnum is not NULL THEN '100600'
else NULL end
AS id_type,
-- 1:个人,2:公司
1 AS yz_type,
-- 工作单位/地址
address AS work_place,
-- 邮箱
NULL AS email,
-- 性别 SUBSTR(idnum,16,17)/2
CASE WHEN idnum is not NULL AND to_number(SUBSTR(idnum, 17, 1))%2 == 0 THEN '女'
else '男' END AS gender,
-- 民族
NULL AS ethnic,
-- 业主编号
RowGuid AS yz_num,
-- 法人姓名
NULL AS legal_name,
-- 统一社会信用代码
NULL AS credit_code,
-- 启用状态:1/启用,2/禁用,3/待审核
1 AS status,
-- 账号来源渠道 xcx web
'xcx' AS channel,
-- 暂时滞空
NULL AS full_area_code,
-- 暂时滞空
NULL AS full_area_name,
-- 暂时滞空
NULL AS area_code,
-- 暂时滞空
NULL AS area_name
from "dbotest"."CQ_WYZJ_YEZHUINFO"

执行查询sql正常 ,加入insert into后报错

回答 0
暂无回答
扫一扫
联系客服