Re: SQL Usage?

[BEllis@xxxxxxxxxxxx]

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

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

3. How do you create tables for development?  Scripts in source PF's?  By
hand?  Programs?  Other (please describe)?
***For newly created tables and indexes, or for tables/indexes created via
SQL. We use SQL scripts in source PF's.
***For existing files and logicals created in DDS we continue to make
changes using DDS.

4. If you use scripts in source pf's, do you create a single table per
script or multiple tables per script?
***Both

5. Do you recreate the tables in your production environment or move them
from your development environment?
***Recreate tables into production environment.  This is the way our change
management system handles it.

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