But in regard to "never ever" referencing files in programs, why would you
say that? Are you suggesting that ONLY SQL views should be referenced in
programs? That wouldn't make a much sense to me.
Why? What happens if you want to modernize and normalize your database by by
splitting big tables into multiple smaller ones.

I you used a view which originally had the same columns in the same table as
the original table, you simply have to modify the view (joining the new
tables together), but you no not have to modify any of your programs.
You do not even have to rework your updates.
Instead of triggers, which can handled inserts, updates or deletes on joined
files/tables can only be added to views.
So you simply have to rework your view and add or modifiy 3 instead of
triggers (one for insert, one for update and one for delete) ... and voilà
that's it

I'd always expect that something like this will happen in the future

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Nathan
Andelin
Sent: Samstag, 2. September 2017 01:10
To: RPG programming on the IBM i (AS/400 and iSeries)
<rpg400-l@xxxxxxxxxxxx>
Subject: Re: SQL and defining data structures


... create view is your friend. You must not reference any file in
your programms anyway, never ever.


I agree that create view is your friend in this case because the original
post indicated that the SQL select statement produced a join of several
files. The OP could reference the view as follows:

dcl-ds dsMYVIEW extname('MYVIEW') qualified end-ds;

But in regard to "never ever" referencing files in programs, why would you
say that? Are you suggesting that ONLY SQL views should be referenced in
programs? That wouldn't make a much sense to me.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].