分组SQL语句 [英] Grouping SQL statements
问题描述
大家好,
i希望将几个sql语句组合成一个并在DataStage中运行它们。
但是,我收到以下错误:
BEGIN
DELETE FROM DEVSTGEV.STG_EV_RSKV_IO;
COMMIT;
INSERT INTO DEVSTGEV.STG_EV_RSKV_IO(L45__HEADER,COMPANY_CODE, POLICY_BR,
POLICY_NO,POLICY_TYP,RISK_NO,SEQ_NO__IO,TERM_ID,TRAN_DATE,TRAN_TIME,
TRAN_USER,VALID_FLAG,RISK_CLASS,DATE_EFFECT,DATE_TERM,PAGE_NUMBER,
HEAD_NO,GEN_NO,RATING_FLAG,CATEGORY,COVER_01,COVER_02,COVER_03,
COVER_04,COVER_05,DESC_01,DESC_02,DESC_03,DESC_04,DESC_05,
SUM_INS_01,SUM_INS_02, SUM_INS_03,SUM_INS_04,SUM_INS_05,PREMIUM_01,
PREMIUM_02,PREMIUM_03,PREMIUM_04,PREMIUM_05,RRN__IO)价值
(?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?);
END;
SQLSTATE = 37000,DBMS.CODE = - 104
[DataStage] [SQL Cli ent] [ODBC] [DataDirect] [ODBC DB2 Wire Protocol
驱动程序] [UDB DB2 for Windows,UNIX和Linux] ILLEGAL SYMBOL FROM;有效
符号开始删除
任何建议!
干杯,
圣。
hi all,
i want to group few sql statements into one and run them in DataStage.
However, i am getting the following error:
BEGIN
DELETE FROM DEVSTGEV.STG_EV_RSKV_IO;
COMMIT;
INSERT INTO DEVSTGEV.STG_EV_RSKV_IO(L45__HEADER, COMPANY_CODE, POLICY_BR,
POLICY_NO, POLICY_TYP, RISK_NO, SEQ_NO__IO, TERM_ID, TRAN_DATE, TRAN_TIME,
TRAN_USER, VALID_FLAG, RISK_CLASS, DATE_EFFECT, DATE_TERM, PAGE_NUMBER,
HEAD_NO, GEN_NO, RATING_FLAG, CATEGORY, COVER_01, COVER_02, COVER_03,
COVER_04, COVER_05, DESC_01, DESC_02, DESC_03, DESC_04, DESC_05,
SUM_INS_01, SUM_INS_02, SUM_INS_03, SUM_INS_04, SUM_INS_05, PREMIUM_01,
PREMIUM_02, PREMIUM_03, PREMIUM_04, PREMIUM_05, RRN__IO) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
END;
SQLSTATE=37000, DBMS.CODE=-104
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol
driver][UDB DB2 for Windows, UNIX, and Linux]ILLEGAL SYMBOL FROM; VALID
SYMBOLS ARE BEGIN DELETE
Any suggestions!
Cheers,
San.
推荐答案
请使用下面的统计信息我猜你的SQL会有效。
BEGIN COMPOUND ATOMIC / END COMPOUND
Please use below stattements I guess ur SQL will then work.
BEGIN COMPOUND ATOMIC / END COMPOUND
这也给出了语法错误。
还有其他选择吗?
This also gave a syntax error.
Any other options?
仅使用BEGIN COMPOUND ATOMIC / END COMPOUND
但不要使用此内的COMMIT语句
use BEGIN COMPOUND ATOMIC / END COMPOUND only
but don''t use the COMMIT statement inside this
这篇关于分组SQL语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!