Change management for development environment

["Nelson, Jim (RCIS)" <Jim.Nelson@xxxxxxxxxxxx>]

Looking for some help maintaining our development environment.

Our policy issuing software is a VB app that uses the AS/400 for our
internal customers and SQLAnywhere for our disconnected agent force.  Many
stored procedures (and triggers, but that's a different story) used.

We use Aldon for promoting to our system test and production environments,
but for various reasons we decided we did not want to control our
development environment that tightly.

Our development process is to create 'builds' that are released to the
functional test group.  With each build we introduce any table schema
changes, and have to recompile all stored procedures that use them.

When functional testing is complete, we use Aldon to move all data schema
and stored procedure changes into the test environment, then to production
on the release date.  

We could sure use a tool to help manage the creation of stored procedures
when a table is changed in development.  I have a guy working on building
it, but would rather have him on the application itself.  

Is there anything out there that could recompile all dependent programs and
stored procedures (both RPG 'wrapper' and SPL) when a table schema is
changed?


Thanks, JN
+---
| 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
+---