RE: SQL DDL and CMS

Scott,

To keep the CM gods happy, you're going to have to check out the original DDL and modify it.

Might check to see if Turnover can be set to use Alter Table/CHGPF when possible; I can do so with
Aldon.

Basically, you check out the original DDL, make your change and promote it. During the promotion,
Aldon will create a temporary version of the new table, that it (somehow) compares to the original.
Aldon will determine the differences, then if possible will issue an appropriate ALTER TABLE statement
to make the original look like the new one.

Actually, Aldon can do the same with DDS defined files by utilizing the CHGPF command.

If it is not possible to use ALTER TABLE/CHGPF, then Aldon goes back to the old method of just copying
the data from the original version to the new.



Charles Wilt
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Scott Johnson
Sent: Friday, February 29, 2008 9:37 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: SQL DDL and CMS

Acronyms aplenty here...

Starting to use SQL DDL to define tables and such instead of DDS. When I
created the table, I speced out the 'Create Table' and used our CMS
(Change
Management System) Softlandings' TurnOver to create/promote the table into
production. This works great. I now need to add a column to the table. I
can check out the original DDL source, make change, and re-promote it. I
could also just open up Navigator and add the column. I could just do a
Alter Table in a SQL window. I am just not sure what the best method is
to
do this change and keep the change management gods happy.

How are people using CMS to handle the DDL? What are the best practices
for utilizing SQL DDL?

-- Thanks!
Scott P. Johnson
Senior Developer/Analyst

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.