Sponsored Links
Sponsored Link

sponsored links

Collapse

Announcement

Collapse
No announcement yet.

DDS to DDL modernization with the added twist of normalization?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • DDS to DDL modernization with the added twist of normalization?

    Thanks to Dan Cruikshank, Kent Milligan, and others, most of us are well familiar with the DDS to DDL conversion using a surrogate LF to keep the RID intact for a db modernization model on IBM i.

    Would anyone know of examples where, rather than a one-to-one direct replacement of PFs to Tables, we would see an original denormalized PF extracted to a header and detail table pair? Creation of the normalized header and detail formats is the easy part. I’m mostly interested in what the “surrogate LF” component would look like here. I have toyed with JLFs but the RIDs change. I can see hydrating the new model with an IOT once that intermediate animal is created.

    Thanks in advance,
    Cliff

sponsored links

Collapse

Working...
X