×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hello Rob,
Am 10.08.2023 um 21:36 schrieb Rob Berendt <robertowenberendt@xxxxxxxxx>:
Here's the problem: "... an existing database file (DDS)".
Quit that. Use SQL's DDL instead. DDL will allow you to default new columns to current date, etc. DDS will NOT. Sure, you can add triggers 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
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.