RE: SQL Usage?

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Answers are in-line:


1. Do you use SQL for AS400 based application development?
1a. No currently but will be shortly.


2. If (1) is No, why not?  [If (1) is no, you can skip the rest of the 
questions]
2a. We just got the SQL development software when we upgraded from a 510 to
a 720.  We are currently learning it and making a plan on when to use SQL
vs. DDS.


3. How do you create tables for development?  Scripts in source PF's?  By 
hand?  Programs?  Other (please describe)?


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

5. Do you recreate the tables in your production environment or move them 
from your development environment?
5a. We always create everything in production.  We like the source to match
the objects.  Makes using Hawkeye much easier.


Looking forward to the results.  This can help us with out SQL
implementation.

Perfect timing David.


Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000
+---
| 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
+---