Re: convert dds to ddl

My frustrations with QSQGNDDL showing through :)


----- Original Message ----- From: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2010 2:18 PM
Subject: AW: convert dds to ddl


I knew it, every time if I think I do not have to mention something someone
points me to it ;)

I'd not use generate SQL to create SQL scripts for indexes and/or views.
I used generate SQL it to get SQL scripts for our DDS described physical
files. But we did not only translate 1:1, instead we added an identity
column to each of the new "physical files" and generated primary key
constraints over the identity column. That will allow us to implement
referential integrities (sometime in future).

Long ago we searched through all our logical files, found the different key
combinations, generated SQL indexes and replaced the DDS described logical
files in our F-Specs.
Unused logical files were removed after. With each new release we could
replace more DDS described logical files. Currently there are only left a
few keyed join files that are used in some F-Specs.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"