Re: Array and PF

[Paul Tuohy <tuohyp@xxxxxxxxxxxxx>]

Hi Eric,

The short answer is No. The reason being that the idea of an array in a record
would break the third rule of normalization (and nothing but the key)..

For example, a record that was defined as CODE, VAL01, VAL02............VAL11,
VAL12 (CODE being the key and the values being 12 months sales values) should
really be defined as CODE, MONTHNO, VALUE (CODE and MONTHNO being the key). You
would end up with 12 records instead of 1.

For what it is worth

Paul Tuohy

Eric Panissard wrote:

> Is there a way to describe an array in a physical or a logical file?
>
> Much thanks
>
> Eric Panissard
> EPanissard@idt.pf
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---