Hi,

I have a flat file which has data defined with occurs clause.
Here is an example of how it looks.

A,B, C1,C2,C3.......C12.

I would like to know how to modify the metadata to be able to convert them to
multiple records while reading the flat file. Here is how I would like it be
converted.
A,B,C1
A,B,C2
A,B,C3
.
.
.
A,B,C12

Thanks.

You define your occurs as a seperate segment.

FILE=FocalPoint, SUFFIX=FIX
SEGNAME=ROOT, SEGTYPE=S0, $
FIELD=A, ALIAS=A, USAGE=A1, ACTUAL=A1, $
FIELD=B, ALIAS=B, USAGE=A1, ACTUAL=A1, $
FIELD=CHOLDER, ALIAS=CHOLDER, USAGE=A12, ACTUAL=A12, $
SEGNAME=CSEG, SEGTYPE=S0, PARENT=ROOT, OCCURS=12, POSITION=CHOLDER, $
FIELD=C, ALIAS=C, USAGE=A1, ACTUAL=A1, $

Hope this helps