Re: SQL within application programs

Dibrell, Branston wrote:
> 
> I think of SQL as being good in terms of being able to separate out your
> front-end programs from your back-end database.  If all access to the
> database was with SQL, you could (in theory) move the database onto another
> box (even another platform) and not affect the programs.
> 
> Actually (I'm no expert, but), I think of SQL as being rather inefficient
> when it comes to complicated queries, etc.
> 

Sometimes SQL will take much longer to accomplish the same thing as RPG
CHAIN/DELETE Etc but in many situations it is as fast or faster.

It is important to remember that the efficiency of SQL is improved from
release to release and routines written in SQL will automatically pick
up these improvements.

Also changes to the underlying database (including the operating system)
are often transparent to the SQL

for Example

DELETE FROM DATAFILE WHERE TYPE = 'OLD'

will work on most systems and on any 'DATAFILE' with a column named TYPE


John Hall
Home Sales Co.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---