为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】：windows
【CPU】:
【问题描述】*：使用dm迁移工具迁移mysql数据到达梦数据库创建视图失败
迁移工具提示【语法分析出错】
具体语句：
CREATE VIEW "DATAVIEW"."V_VILLAGE_DATA" ("所属镇街","单位名称","单位编码","村社编号","案卷级目录","案件级目录","原文数量","实物目录","照片目录","录音录像目录")
AS
select "DAC"."AREA_NAME" AS "所属镇街","VILLAGE"."NAME" AS "单位名称","VILLAGE"."CODE" AS "单位编码","VILLAGE"."FONDS" AS "村社编号",ifnull("DAC2"."案卷级目录",0) AS "案卷级目录",ifnull("DAC2"."案件级目录",0) AS "案件级目录",(ifnull(sum(if((("SSD"."COLLECTION_WAY" = 'volume') and ("SSD"."ARCHIVE_TYPE" = 'da_record')),"SSD"."COUNT",0)),0) + ifnull(sum(if(("SSD"."COLLECTION_WAY" = 'record'),"SSD"."COUNT",0)),0)) AS "原文数量",ifnull("DAC2"."实物目录",0) AS "实物目录",ifnull("DAC2"."照片目录",0) AS "照片目录",ifnull("DAC2"."录音录像目录",0) AS "录音录像目录" from ((("DATAVIEW"."DV_UNIT" "VILLAGE" left join (select ifnull(sum(ifnull("DAC2"."VOLUME",0)),0) AS "案卷级目录",ifnull(sum((ifnull("DAC2"."RECORD",0) + ifnull("DAC2"."INNER_RECORD",0))),0) AS "案件级目录",ifnull(sum(if(("DAC2"."FIRST_CATEGORY" = '实物档案'),((ifnull("DAC2"."VOLUME",0) + ifnull("DAC2"."RECORD",0)) + ifnull("DAC2"."INNER_RECORD",0)),0)),0) AS "实物目录",ifnull(sum(if(("DAC2"."FIRST_CATEGORY" = '照片档案'),((ifnull("DAC2"."VOLUME",0) + ifnull("DAC2"."RECORD",0)) + ifnull("DAC2"."INNER_RECORD",0)),0)),0) AS "照片目录",ifnull(sum(if(("DAC2"."FIRST_CATEGORY" = '录音录像档案'),((ifnull("DAC2"."VOLUME",0) + ifnull("DAC2"."RECORD",0)) + ifnull("DAC2"."INNER_RECORD",0)),0)),0) AS "录音录像目录","DAC2"."UNIT_CODE" AS "UNIT_CODE" from "DATAVIEW"."DV_ARCHIVES_CATEGORY" "DAC2" group by "DAC2"."UNIT_CODE") "DAC2" on(("DAC2"."UNIT_CODE" = "VILLAGE"."CODE"))) left join "DATAVIEW"."SG_STORAGE_DIGITIZATION" "SSD" on((("VILLAGE"."CODE" = convert("SSD"."UNIT_CODE" using utf8mb4)) and ("SSD"."TAB_TYPE" = 1) and ("SSD"."CARRIER_TYPE" = '01') and ("SSD"."RETENTION_PERIOD" in ('C','D30','Y'))))) join "DATAVIEW"."DV_AREA_CODE" "DAC" on((convert("DAC"."CODE" using utf8mb4) = "VILLAGE"."AREA_CODE"))) where ("VILLAGE"."AREA_CODE" is not null) group by "VILLAGE"."CODE" order by NULL