事务。。大神们帮忙解释下这段代码的含义
0
insert /+ APPEND / into <%=snpRef.getTable("L", "INT_NAME", "W")%>
(
<%=snpRef.getColList("", "", ",\n\t", "", "(((INS OR UPD) AND NOT TRG) AND REW)")%>,
IND_UPDATE
)
select <%=snpRef.getUserExit("OPTIMIZER_HINT")%> <%=snpRef.getPop("DISTINCT_ROWS")%>
<%=snpRef.getColList("", "", ",\n\t", "", "(((INS OR UPD) AND NOT TRG) AND REW)")%>,
<%if (snpRef.getPop("HAS_JRN").equals("0")) {%>
'I' IND_UPDATE
<%}else{%>
JRN_FLAG
<%}%>
from <%=snpRef.getFrom()%>
where (1=1)
<%=snpRef.getJoin()%>
<%=snpRef.getFilter()%>
<%=snpRef.getJrnFilter()%>
<%=snpRef.getGrpBy()%>
<%=snpRef.getHaving()%>
minus
select
<%=snpRef.getColList("","", ",\n\t", "", "(((INS OR UPD) AND NOT TRG) AND REW)")%>,
'I' IND_UPDATE
from <%=snpRef.getTable("L", "TARG_NAME", "A")%>
(
<%=snpRef.getColList("", "", ",\n\t", "", "(((INS OR UPD) AND NOT TRG) AND REW)")%>,
IND_UPDATE
)
select <%=snpRef.getUserExit("OPTIMIZER_HINT")%> <%=snpRef.getPop("DISTINCT_ROWS")%>
<%=snpRef.getColList("", "", ",\n\t", "", "(((INS OR UPD) AND NOT TRG) AND REW)")%>,
<%if (snpRef.getPop("HAS_JRN").equals("0")) {%>
'I' IND_UPDATE
<%}else{%>
JRN_FLAG
<%}%>
from <%=snpRef.getFrom()%>
where (1=1)
<%=snpRef.getJoin()%>
<%=snpRef.getFilter()%>
<%=snpRef.getJrnFilter()%>
<%=snpRef.getGrpBy()%>
<%=snpRef.getHaving()%>
minus
select
<%=snpRef.getColList("","", ",\n\t", "", "(((INS OR UPD) AND NOT TRG) AND REW)")%>,
'I' IND_UPDATE
from <%=snpRef.getTable("L", "TARG_NAME", "A")%>
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-03-24 回答
赞同来自: