RE: New DB Performance Boost - For SQL Only!

[Pete Hall <pbhall@xxxxxxxxxx>]

At 10:17 07/04/2000 , Al Barsa wrote:
>What those DODO heads miss is that DDS is significantly more programmer 
>productive than SQL for database definition.  They miss this because they 
>don't use the AS/400 to run their business.

I agree, at least about the DDS part. I much prefer SQL for writing views. 
The grouping and conditional capabilities make it much more powerful than 
DDS. I had to write a special command to execute DDL so that I can use it 
with Implementer.

I like to use SQL in RPG because it allows me to put the grunt work in the 
SQL and concentrate on the things that really need programming. I also 
agree that the compiler directive method of coding is less than optimal. 
Something closer to the look and feel of an SQL stored procedure would be 
ideal. Although that is in reality a single command, it feels just like a 
program. Some kind of begin and end block construct that allows multiple 
SQL statements in line would be a big help. By the time you get done 
writing 5 or 6 /SQL EXEC blocks with the requisite tests for SQL code or 
state between them, it can become really hard to find the program. The 
power makes the down side tolerable, but it's sure ugly.


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall
+---
| 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
+---