Re: SQL Usage?

[Pete Hall <pbhall@xxxxxxxxxx>]

At 06:39 03/02/2001, David Gibbs wrote:

>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)?
Usually with DDS. We use Implementer, and it handles DDS better than 
scripts. For views and indexes, it's often necessary to use scripts anyway 
because DDS can't do it. Sometimes build temporary result set tables in 
QTEMP with CREATE TABLE in stored procedures.

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

>5. Do you recreate the tables in your production environment or move them 
>from your development environment?
Recreate

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