Source-derived document; reported behaviour, inference and evidence gaps are identified in the text.

Return to: C06 — Conceptual Information Model — topic detail

State reference records

Data: State reference records

state.unl contains newline-separated state entries with two-letter uppercase codes, names, and trailing pipe delimiters, such as AK|Alaska|. The visible excerpt runs from AK/Alaska through ME/Maine and includes CA/California, TX/Texas, and NY/New York. E0009

query1.4gl.main loads state rows ordered by sname into an array, stopping after the array count exceeds 50. statehelp() opens the state-selection window, displays the loaded states, obtains the selected array index, assigns the selected code to p_customer.state, and closes the window. The state form declares seven repeated rows and maps state.code and state.sname to its displayed fields. E0009