RE: SQL vs native access

Joe,

Try the following article:

http://iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=view
article&CO_ContentID=16376&channel=

and the following page on DB2:

http://www-1.ibm.com/servers/eserver/iseries/db2/sqe.html

In particular, the "SQL Query Enhancements Redpiece" has an explanation
of what resides below the MI. See Chapter 2.


Regards,

John Taylor

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
> Sent: Friday, August 22, 2003 2:20 PM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: SQL vs native access 
> 
> 
> > From: Walden H. Leverich III
> > 
> > I think that was true prior to 5.2. In <=5.1 SQL actually accessed
> data
> > through the same SLIC primatives as single record 
> operations. However,
> in
> > 5.2 SQL has a new query engine (below the MI) and its own 
> set of SLIC 
> > primatives so I'm tempted to say that common sense may see a change.
> 
> According to Jon Paris' post, this doesn't seem to be the 
> case, Walden. Do you have any type of formal information on 
> this, or are you just guessing?
> 
> Joe
>