Re: Working with tables, best method

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