RE: SQL Usage?

["Mark Villa" <markvilla@xxxxxxxxxxx>]

>>1. Do you use SQL for AS400 based application development?


No, but makes a great mass update tool for those without tools.

>>2. If (1) is No, why not?  [If (1) is no, you can skip the rest of the
>>questions]

1) Customers don't have or want the SQL License
2) historically slower
3) set at a time processing vs. record processing can be an issue
4) takes more skill to do with same dollars for overhead, maintain, etc.
5) Database tables must be of good design to get the task completed using
this as a programming platform without resorting to 3GL.
6) advantages of SQLexec has not been understood and a last resort
mentality.
7) Most of the work, at least 50.1 %, for business application modifications
requires logic that is more difficult to implemented in SQL.


+---
| 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
+---