Procedures and functions, whether written in SQL or in traditional application development languages, provide powerful tools for accessing your database.
By Kevin Forsythe
One of the most difficult tasks when you're designing an application is deciding how to code each portion of the application. We can develop applications in CL, RPGLE, SQL, and a host of other languages. The capabilities of these languages overlap one another to a certain degree, so the decision of which language to use is not always clear-cut.