Re: AW: convert dds to ddl

[Gqcy <gmufasa01@xxxxxxxxx>]

when you added the identity column, you got a different format id?

-gerald


Birgitta Hauser wrote:
> 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