|
Hello Rob,
Am 10.08.2023 um 21:36 schrieb Rob Berendt <robertowenberendt@xxxxxxxxx>:
Here's the problem: "... an existing database file (DDS)".columns to current date, etc. DDS will NOT. Sure, you can add triggers
Quit that. Use SQL's DDL instead. DDL will allow you to default new
and stuff but that isn't really DDS, is it?
You are correct about DDS lacking helpful features compared to SQL[1].
However, the convenience of DDS being a sole source for generating the
table object, and recreating that object is a matter of typing 14 beneath
the source member in PDM (or bringing the source member and the PF in sync
with chgpf) appears to me superior compared to SQL. I think this fact might
be especially important for developers with testing environments.
I have not yet found out how to get a textual table definition with pure
5250 tools, that I can just shove through runsqlstm to regenerate an SQL
table equally easily, compared to DDS.
Manual adjustment of a text member becomes hairy when one forgets to a) do
it and b) the syntax of table alteration is different than the one for
creating it (and beingg the content of the text member) which creates more
possibilities to fail at a future point in time. Thus, this is not a viable
solution for (at least) me.
[1] With my V4R5 box, the number of helpful features compared to DDS is
equally low as my motivation to "let go" of DDS. ;-)
:wq! PoC
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.