为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:错误号: -2007
错误消息: 第 136 行, 第 7 列[COMMIT]附近出现错误:
语法分析出错
CREATE OR REPLACE VIEW "PLATFORMGY"."DUE_ALL_INFO" ("ID","DUEBILL_CODE","COOPERATION_NAME","CUST_CODE","CUST_NAME","UNISOCCRE_CODE","FINANCIAL_LICENSE_NUMBER","BANK_RATE","BOND_TYPE","CONTRACT_NAME","PUTOUT_DATE","MATURITY_DATE","AMOUNT","CREDIT_WAY","CAPITAL_TYPE","BUSINESS_TYPE","BUSINESS_ORG","OPERATE_ORG","OPERATE_USER","SPECIAL_INDUSTRY","INVESTTYPE","UPDATE_TIME","ASSET_TYPE","INVEST_INDUSTRY","BUSINESS_TYPE_INVEST","ACCOUNT_ID","FUND_PROVIDER_TYPE")
AS
SELECT "ID",
"DUEBILL_CODE",
"COOPERATION_NAME",
"CUST_CODE",
"CUST_NAME",
"UNISOCCRE_CODE",
"FINANCIAL_LICENSE_NUMBER",
"BANK_RATE",
"BOND_TYPE",
"CONTRACT_NAME",
"PUTOUT_DATE",
"MATURITY_DATE",
"AMOUNT",
"CREDIT_WAY",
"CAPITAL_TYPE",
"BUSINESS_TYPE",
"BUSINESS_ORG",
"OPERATE_ORG",
"OPERATE_USER",
"SPECIAL_INDUSTRY",
"INVESTTYPE",
"UPDATE_TIME",
asset_type,
Invest_Industry,
BUSINESS_TYPE_INVEST,
ACCOUNT_ID,
FUND_PROVIDER_TYPE
FROM (SELECT D.ID,
D.DUEBILL_CODE,
C.CUST_NAME AS COOPERATION_NAME, --??????
C1.CUST_CODE AS CUST_CODE, --?????,
C1.CUST_NAME AS CUST_NAME, --?????
C1.UNISOCCRE_CODE, --?????????
C.FINANCIAL_LICENSE_NUMBER,--??????
E.BANK_RATE, --?????
E.BOND_TYPE, --??????
D.CONTRACT_NAME, --????
D.PUTOUT_DATE, --???
D.MATURITY_DATE, --???
D.AMOUNT, --????
-- E.VOUTH_TYPE AS CREDIT_WAY,
CG.GUARANTY_WAY AS CREDIT_WAY,--????
E.CAPITAL_TYPE, --????
D.INVEST_TYPE BUSINESS_TYPE,--????????
-- E.BUSINESS_TYPE,
E.BUSINESS_ORG, --?????
E.OPERATE_ORG, --????
E.OPERATE_USER, --????
E.SPECIAL_INDUSTRY, --??????
D.INVESTTYPE,--???????
E.UPDATE_TIME,
D.asset_type,
D.Invest_Industry,
D.BUSINESS_TYPE_INVEST,
C3.ACCOUNT_ID,
C3.FUND_PROVIDER_TYPE
FROM INTM_BUSINESS_EXTEND E
INNER JOIN INTM_BUSINESS_DUEBILL D
ON D.ID = E.BUSINESS_ID
LEFT JOIN
(SELECT RELATED_BUSINESS_CODE,
GUARANTY_WAY
FROM COMM_GUARANTY_CONTRACT A,
COMM_GUARANTY_RELATION B
WHERE A.ID = B.RELATED_BUSINESS_ID
AND B.IS_MAIN_GUAR = 'Y'
) CG ON CG.RELATED_BUSINESS_CODE = D.DUEBILL_CODE
INNER JOIN intm_asset_trade_detail C2
ON C2.asset_code = D.Duebill_Code
INNER JOIN intm_asset_trade C3
ON C3.ID = C2.BUSINESS_ID
INNER JOIN COMM_COMPCUST C
ON E.COOPERATION_ID = C.ID
INNER JOIN COMM_COMPCUST C1
ON E.CUST_ID = C1.ID
WHERE D.EFTFLAG = 'E'
UNION ALL
SELECT D.ID,
D.DUEBILL_CODE,
C1.CUST_NAME AS COOPERATION_NAME, --??????
B.CUSTOMER_CODE AS CUST_CODE, --?????
B.CUSTOMER_NAME AS CUST_NAME, --?????
C.UNISOCCRE_CODE, --????????????
C1.FINANCIAL_LICENSE_NUMBER, --?????????
CON.BANK_RATE AS BANK_RATE, --?????
O.FUND_ASSET_TYPE AS BOND_TYPE, -- ???????
D.CONTRACT_NAME, --????
D.PUTOUT_DATE, --???
D.MATURITY_DATE, --???
D.AMOUNT, --????
CG.GUARANTY_WAY AS CREDIT_WAY, --????
O.FUND_NATURE AS CAPITAL_TYPE, --????
O.INVEST_TYPE AS BUSINESS_TYPE, --????????
O.OPERATE_ORG AS BUSINESS_ORG,
O.OPERATE_ORG,
O.OPERATE_USER,
B.INDUSTRY_TYPE1, --??????
D.INVESTTYPE,--???????
O.UPDATE_TIME,
D.asset_type,
D.Invest_Industry,
D.BUSINESS_TYPE_INVEST,
C3.ACCOUNT_ID,
C3.FUND_PROVIDER_TYPE
FROM INTM_OWNFUND_INFO O
INNER JOIN INTM_PROJECT_INFO P
ON O.BUSINESS_ID = P.ID
INNER JOIN BUSINESS_BORROWER B
ON B.RELATED_BUSINESS_ID = P.ID
INNER JOIN COMM_COMPCUST C
ON B.CUSTOMER_CODE = C.CUST_CODE
INNER JOIN INTM_TRADING_CONTRACT CON
ON CON.APPLY_ID = P.ID
INNER JOIN COMM_COMPCUST C1
ON CON.COOPERATION_ID = C1.ID
INNER JOIN INTM_BUSINESS_DUEBILL D
ON CON.BUSINESS_ID = D.ID
LEFT JOIN
(SELECT RELATED_BUSINESS_CODE,
GUARANTY_WAY
FROM COMM_GUARANTY_CONTRACT A,
COMM_GUARANTY_RELATION B
WHERE A.ID = B.RELATED_BUSINESS_ID
AND B.IS_MAIN_GUAR = 'Y'
) CG ON CG.RELATED_BUSINESS_CODE = D.DUEBILL_CODE
INNER JOIN intm_asset_trade_detail C2
ON C2.asset_code = D.Duebill_Code
INNER JOIN intm_asset_trade C3
ON C3.ID = C2.BUSINESS_ID
WHERE D.EFTFLAG = 'E')
COMMIT
commit前面加一个分号试试

把commit去掉试试