Thanks very much to Mark for your considerable time which I hope will benefit many others on the list apart from myself.
We do select the individual columns when imbedding SQL.
But, given that the field analysis must be made anyway, and if the host receptor structure is impacted by the change the sourc modified, dare I say this : ? Why not systematically specify SELECT *, create the host structure based on an external file and systematically recompile the whole kit and keboodle?
<Hesitating before clicking the send button and going home for the weekend>
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de rob@xxxxxxxxx
Envoyé : vendredi 7 novembre 2008 15:44
À : Midrange Systems Technical Discussion
Objet : Re: Homegrown CMS and SQLRPG(LE)
The question boils down to "Why do you care - if you are using SQL?"
1 - Never use "select *". Always select the individual columns when imbedding SQL.
2 - If you use an externally defined data structure you should be ok with a recompile. Like fetch mycol1, mycol2 into :myExtDs.mycol1, :myExtDs.mycol2 ...
Now, you just have to figure out the reference on externally defined data structures. Do they show up on DSPPGMREF?
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From:
David FOXWELL <David.FOXWELL@xxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
11/07/2008 04:30 AM
Subject:
Homegrown CMS and SQLRPG(LE)
Sent by:
midrange-l-bounces@xxxxxxxxxxxx
Hi,
Starting a new thread, the last on handling views was short-lived. Vern, thanks, I've saved your input for when we get started on that issue.
Our "CMS" will automatically recompile all modules and programs if a file changes and that file is referenced in a program. By using DSPPGMREF. Of course, in an SQLRPG, this doesn't work. Would anyone like to share how they are dealing with this problem?
Maybe this should be on the RPG list?
Thanks.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.