Re: Embeded SQL in RPG what are some good scenarios where it would be useful?

1 - Record layout independence.
If you have an application that spans multiple versions of the same vendor 
software and you want to use one version of custom programming.  And you 
don't want native rpg's record format level check.  We did have an 
application that used SQL for just that situation.
2 - Trying to select/sort on the fly.
Let's say you have a subfile full of records.  Now the user wants to click 
on a column and sort by that column.
3 - Anything that you might use OPNQRYF for.
'nuff said.
4 - Use of functions not available in RPGLE.  Like SOUNDEX.
5 - Large set-at-a-time updates and selects.

Many of this stuff could be done in RPG.  But it may not be as productive 
as with SQL.  And there may be certain cases where SQL could outperform 
doing the same function in RPGLE.  Although never assume anything on that.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Andy Hautamaki" <ahautamaki@xxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/22/2005 11:37 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG400-L@xxxxxxxxxxxx" <RPG400-L@xxxxxxxxxxxx>
cc

Subject
Embeded SQL in RPG what are some good scenarios where it would be useful?






This is an innocent question and I hope this doesn't lead to an all out 
war
on the virtues of using SQL........... :}

I'm curious on what are some situations when it would be a good idea to 
use
embedded SQL in RPG?

Sorry for the very broad question, but I'm not very familiar with using it
in RPG and wanted to know if its something I should learn more about.

Andy




-- 
This is the RPG programming on the AS400 / 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.