Re: advantages of using embedded sql

From: Alan Campin
You are still locking the table format into the program. Add a new field
to the table and your program crashes and you must recompile unless
you turn off format checking which is basically playing Russian roulette.

We really don't think twice about adding new fields to record layouts, or rebuilding our programs and services programs affected by the changes. We wrote a CL command that submits a job that scans through our RPG source members and automatically rebuilds programs and service programs that are affected by record layout changes. We use record level access extensively. And we use dynamic SQL extensively. If you use just one or the other exclusively, you're going to end up with mediocre applications.

-Nathan