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

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.