Re: Storing source as DDL instead of DDS

Rob:

Note that if the file is journaled, there will be journal entries to indicate an ALTER TABLE (or CHGPF) took place, and exactly what was modified in the file definition, so that remote journaling and replication software can apply the same changes on the target system(s).

Your idea for some kind of new indicator or flag to indicate "definition changed outside of source" is interesting and might make a nice RFE...

Thanks,
Mark S. Waterbury

> On 2/27/2017 8:52 AM, Rob Berendt wrote:

There's a difference between "should not permit" and reality. Hence the
reason for the audit.

It was nice to know that they do use those items on RUNSQLSTM also

But basically that source file change/date stuff doesn't have any type of
"definition changed outside of source" kind of flag.

Rob Berendt