BD2 设置

哈孙军 2009-06-07 08:01:46

jbpm下 DB2生成的语句太长了。因为超过长度或复杂度方面的系统限制。下面是我的SQL语句，
是不是系统哪个变量设置一下我的语句就可以执行了。

select （---------------------------------------满多的-----------------------------------------------）

from JBPM_TASKINSTANCE taskinstan0_ left outer join JBPM_TASK task1_ on taskinstan0_.TASK_=task1_.ID_
left outer join JBPM_PROCESSDEFINITION processdef2_ on task1_.PROCESSDEFINITION_=processdef2_.ID_ left
outer join JBPM_NODE startstate3_ on processdef2_.STARTSTATE_=startstate3_.ID_
left outer join JBPM_PROCESSDEFINITION processdef4_ on startstate3_.PROCESSDEFINITION_=processdef4_.ID_
left outer join JBPM_ACTION action5_ on startstate3_.ACTION_=action5_.ID_
left outer join JBPM_ACTION action6_ on action5_.REFERENCEDACTION_=action6_.ID_
left outer join JBPM_DELEGATION delegation7_ on action6_.ACTIONDELEGATION_=delegation7_.ID_
left outer join JBPM_PROCESSDEFINITION processdef8_ on delegation7_.PROCESSDEFINITION_=processdef8_.ID_
left outer join JBPM_EVENT event9_ on action6_.EVENT_=event9_.ID_
left outer join JBPM_PROCESSDEFINITION processdef10_ on action6_.PROCESSDEFINITION_=processdef10_.ID_
left outer join JBPM_ACTION action11_ on action6_.TIMERACTION_=action11_.ID_
left outer join JBPM_NODE superstate12_ on startstate3_.SUPERSTATE_=superstate12_.ID_
left outer join JBPM_MODULEDEFINITION taskmgmtde13_ on task1_.TASKMGMTDEFINITION_=taskmgmtde13_.ID_
left outer join JBPM_PROCESSDEFINITION processdef14_ on taskmgmtde13_.PROCESSDEFINITION_=processdef14_.ID_
left outer join JBPM_TASK task15_ on taskmgmtde13_.STARTTASK_=task15_.ID_
left outer join JBPM_NODE tasknode16_ on task15_.TASKNODE_=tasknode16_.ID_
left outer join JBPM_NODE startstate17_ on task15_.STARTSTATE_=startstate17_.ID_
left outer join JBPM_DELEGATION delegation18_ on task15_.ASSIGNMENTDELEGATION_=delegation18_.ID_
left outer join JBPM_SWIMLANE swimlane19_ on task15_.SWIMLANE_=swimlane19_.ID_
left outer join JBPM_DELEGATION delegation20_ on swimlane19_.ASSIGNMENTDELEGATION_=delegation20_.ID_
left outer join JBPM_MODULEDEFINITION taskmgmtde21_ on swimlane19_.TASKMGMTDEFINITION_=taskmgmtde21_.ID_
left outer join JBPM_TASKCONTROLLER taskcontro22_ on task15_.TASKCONTROLLER_=taskcontro22_.ID_
left outer join JBPM_DELEGATION delegation23_ on taskcontro22_.TASKCONTROLLERDELEGATION_=delegation23_.ID_
left outer join JBPM_TOKEN token24_ on taskinstan0_.TOKEN_=token24_.ID_
left outer join JBPM_NODE node25_ on token24_.NODE_=node25_.ID_
left outer join JBPM_PROCESSDEFINITION processdef26_ on node25_.SUBPROCESSDEFINITION_=processdef26_.ID_
left outer join JBPM_DELEGATION delegation27_ on node25_.DECISIONDELEGATION=delegation27_.ID_
left outer join JBPM_PROCESSINSTANCE processins28_ on token24_.PROCESSINSTANCE_=processins28_.ID_
left outer join JBPM_PROCESSDEFINITION processdef29_ on processins28_.PROCESSDEFINITION_=processdef29_.ID_
left outer join JBPM_TOKEN token30_ on processins28_.ROOTTOKEN_=token30_.ID_
left outer join JBPM_TOKEN token31_ on token30_.PARENT_=token31_.ID_
left outer join JBPM_TOKEN token32_ on processins28_.SUPERPROCESSTOKEN_=token32_.ID_
left outer join JBPM_SWIMLANEINSTANCE swimlanein33_ on taskinstan0_.SWIMLANINSTANCE_=swimlanein33_.ID_
left outer join JBPM_SWIMLANE swimlane34_ on swimlanein33_.SWIMLANE_=swimlane34_.ID_
left outer join JBPM_MODULEINSTANCE taskmgmtin35_ on swimlanein33_.TASKMGMTINSTANCE_=taskmgmtin35_.ID_
left outer join JBPM_PROCESSINSTANCE processins36_ on taskmgmtin35_.PROCESSINSTANCE_=processins36_.ID_
left outer join JBPM_MODULEDEFINITION taskmgmtde37_ on taskmgmtin35_.TASKMGMTDEFINITION_=taskmgmtde37_.ID_
left outer join JBPM_MODULEINSTANCE taskmgmtin38_ on taskinstan0_.TASKMGMTINSTANCE_=taskmgmtin38_.ID_

...全文