Re: Working with tables, best method

[Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>]

Sounds nice... and sometimes, frying the minds of purists
(any kind) is not so bad an idea :-)

Regards,

Luis

--- rpg400-l-request@xxxxxxxxxxxx wrote:

> message: 1
> date: Fri, 15 Feb 2008 09:00:26 -0500
> from: @dekko.com
> subject: Re: Working with tables, best method
>
> Don't forget the CHAIN also has an F spec.  And, the
> cycle automatically 
> opens the file previously.  Closes are handled
> differently.
>
> I suppose if you could
> exec sql Declare FileAcursor cursor for
> OhJustOpenThisFile;
> exec sql select ... from FileAcursor where ...;
> exec sql close FileAcursor;
>
> But I bet that select statement would fry the minds of an
> sql purist.
>
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> >
> Luis Rodriguez <luis...@xxxxxxxxx> 

> Subject
> Re: Working with tables, best method
> --- rpg400-l-request@xxxxxxxxxxxx wrote:
> > ------------------------------
> >
> > message: 3
> > date: Thu, 14 Feb 2008 17:42:37 -0600
> > from: Joe Pluta <j...@xxxxxxxxxxxxxxxxx>
> > subject: Re: Working with tables, best method
>
> <Big cut here...>
> > I stand by the fact that single record chains and
> updates
> > still 
> > outperform SQL.
>
> <....>
> Joe,
>
> (Not trying to begin a long thread here, just being
> curious?)
> Although, of course, the decision to use either SQL or
> RPG
> (or combination of both) is a business decision, I concur
> that Single Record Access (SLA) in RPG is always faster
> than SLA in SQL.
>
> My question is, why is this so? If I work with SQLRPGLE,
> IBM translates my SQL instructions to an intermediate
> code,
> before compiling my program. Couldn't it be possible to
> use
> a special SQL instruction (e.g. SELECT * FROM TABLE WITH
> SLA) and then have the precompiler (either RPG or the DB
> interpreter) convert it to a CHAIN (or UPDATE)?. Just
> wishful thinking, I know, just wondering?
>
> Regards,
> Luis Rodriguez


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping