Re: Can I use DDS to create an SQL table name

Just wanted to address a couple of points

On Wed, Oct 22, 2014 at 7:10 AM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

Besides that there are tons of DDS out there and converting these to DDL is
not only a waste of time but may also interfere with existing Change
Management systems.

​I would expect CM system to be able to handle this. I know Aldon does. I
check out a DDS PF object, change it DDL *TABLE​ and promote it back. No
issues. Just like I can check out a OPM RPG III object and convert it to
an ILE RPG IV *MODULE or *PGM object.

I have looked into making a Data Definition/Change Management system based
on DDL and that is far more complicated than initial meets the eye because
the structure of SQL where columns and its properties can't be defined in a
single statement and SQL doesn't have the automatization level that
DDS/CHGPF (that implement all changes to a DB object in one command) has.

​Again, a smart enough CM can handle this. Aldon checks to see rather or
not it can use CHGPF or ALTER TABLE before resorting to recreating the file
or table.​