Re: RPG SQL and Cursors

I agree absolutely that you can use field select logicals. I have built
entire systems that way but it is a lot of work as you have to create a
logical view for each program. You can make it easier with a tool but still
difficult and the problem is that it will be absolutely impossible to get
someone else to create the necessary logicals. Programmers will just not do
it. SQL just make it easy.

I have wanted for years to create a tool that would allow you create field
select logicals and externalize the I/O but I know it is a waste of effort
because no one will use it.

<<First: recompiling is not that bad. >>

Then how come in ever shop I have worked in over 20 years they never do?
Instead they create extension tables or new table, etc forever. No one
recompiles or I have never seen it unless it is a new table or something
used in only a couple of programs.

On Thu, Nov 18, 2010 at 5:36 PM, Lennon_s_j@xxxxxxxxxxx <
lennon_s_j@xxxxxxxxxxx> wrote:

Probably most shops are this way, and it is hard to get away from in an
existing databse, but you can get essentially the same level of
independence with RLA as you can using SQL. Instead of reading the
physical, use LFs and explicitly specify the fields in the LF. You can
then change the underlying physical and no program need to be recompiled.

However, I personally find explicit field specification in SQL (SELECT
fieldname, fieldname, as opposed to SELECT *) to be easier.

Sam

On 11/18/2010 6:32 PM, Alan Campin wrote:

When you use RLA, unless you externalize your I/O somehow (which almost

no

one know how to do and won't use it even if you did), you are bringing

the

entire record into the program which in effect, locks the table to

change.

That means the next time you need to change the table you have to

recompile

every program that uses it and very quickly no wants to recompile 500
programs so they start creating extension tables or reusing fields or god
knows what.

--
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.