Pinned topic Why not use PROGRAM TYPE SUB in all your procedures?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I was just reading something about using this in procedures so they ran at a lower level like functions and completed more quickly. What is the downside to this? It almost seems like you would want to put this in every stored procedure.
Updated on 2013-01-17T22:11:43Z at 2013-01-17T22:11:43Z by krmilligan
krmilligan 120000MDWP450 Posts
Re: Why not use PROGRAM TYPE SUB in all your procedures?2013-01-17T22:11:43ZThis is the accepted answer. This is the accepted answer.Essentially when the SQL Procedure support was first delivered PROGRAM TYPE MAIN was the only implementation available. PROGRAM TYPE SUB causes DB2 to use a Service Program object instead of a Program object to speed-up performance. If backward compatibility wasn't a concern, the default value would have been changed to PROGRAM TYPE SUB.