Re: advantages of using embedded sql -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

I have to admit - this would be cool.

how would this work with file overrides in the programs and and useropens?
do you have a library with all possible files specified by programs? would
it work for changes to output from dspfd if that format should change? just
curious.

Jim

message: 4
date: Thu, 8 Sep 2011 09:18:56 -0700 (PDT)
from: Nathan Andelin <nandelin@xxxxxxxxx>
subject: 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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.