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