Actions in Appication Engine

1 Answers

1. 
   

   
   

   Ravi on Apr 05, 2013 Reply

   SQL and Call Section are mutually exclusive.

   This is due to following:
   1. If a SQL action is followed by a Call Section in same step. You now have data which is not committed as part of the SQL action. Now if Call Section also call Sections which does processing on this data, results may not be predictable.

   Example:
   Section : I
   Step I
   SQL : Update Set x=x*2 from table1 where x<y;
   Call Section Section II

   Section II
   SQL: Update Set x=x*4 from table1 where x<z;

   Now to avoid any such situation SQL and Call Section are mutually exclusive.

   +3 Votes 0 Votes  0 Votes