Creating Dataviews for CA Datacom/DB Native Command Access › Rules for CA Datacom/DB Native Command Access › Cataloging the Dataview › VariablyRepeating Occurrences

VariablyRepeating Occurrences

The CA Ideal user is restricted to one variably‑repeating (DEPENDING‑ON) item in a dataview. The DEPENDING‑ON control field must be a non‑occurring elementary numeric identifier (with zero decimal positions) that appears previously in the same dataview. The variably‑repeating field or group and all of its subordinates, if any, must be at the end of the data structure. In other words, a variably‑repeating simple (elementary) field must be the last field in a dataview. A variably‑repeating compound (group) item can have subordinate items, but it cannot be followed in the dataview by any non‑subordinate fields. A variably‑repeating group cannot have initial values. Also, a variably‑repeating item cannot be embedded in another repeating group.