Tweet
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
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