Re: (Date/Time fields in DB file)

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