EXEC statement PSTEP2 in PROC1 is processed. This statement does not change the values of the symbols. However, because the expansion of PROC2 is complete, the values of the symbols return to the level 1 values
unlike the current procedure, is not dependent upon the data volume of the involved tables. We still pullout tables based on volume if this is a direct execution, though. The practical implication of this is as follows: - Only outer tables containing zero or one rows will now be extracted...