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

How many utilities really respect EDTCDE and EDTWRD? Are these 5250 based
utilities only?

I think the simplicity of change management is up to the beholder. IOW I
think it involves a whole new paradigm shift.
Both DDS and DDL support the system catalog. As long as you have evolved
out of the primordial swamp and no longer prefix each column name in each
table differently, like calling the same column IXCNAM, RCCNAM, OECNAM in
each table where the first two characters indicate table, it's quite easy
to use the system catalog and find where the column is used, and alter it
accordingly.

As far as item c and the referential information are you talking about the
field reference file methodology? Since the advent of the system catalog
(V3R1) is it really that great of a thing anymore?

One of the biggest problems I have with DDS is that so much is not in it
that people do not take advantage. Sure, you can do ADDPFCST and whatnot
but since it is not imbedded into DDS people don't use it. It's easier
for people to consider it when it is part of DDL and it's simple enough
that even the prompter from STRSQL can handle a bulk of it.


Rob Berendt