You are here: Available Utilities > V > VRF2EXP > Format 1

Format 1 - Extract file

The format of a flat extract file is shown here:

Pos 1 to 6 Numeric relative merge set within the VRF file

Pos 7 Blank

Pos 8 Record-type flag

M = Begins a merge set

T = A merge tag/data record

E = Ends a merge set

Pos 9 Blank

Pos 10 to 49 Merge tag name

Pos 50 Blank

Pos 51 to 56 Numeric length of data

Pos 57 Blank

Pos 58 Data (any length)

<EOR - CR/LF>

You can use the /F=1 option, as shown here, to generate an extract file:

VRF2EXP /I=MYFILE.VRF /F=1 /KEY1=MYGROUP1 /KEY2=MYGROUP2

For each merge set found in the VRF file, the utility generates and writes a block of records to the extract file. Merge tags are written as T records. Merge forms are written as F records. The generated extract file would look similar to this example:

000001 M MYGROUP1 MYGROUP2

000001 T BILL.STUB 000031 --- STATEMENT OF ACCOUNT ---

000001 T DOCUMERGE.ID.TAG 000012 FO 123456789

000001 T DMG.MERGESET.ID 000012 FO 123456789

000001 T PIF.SYMBOL 00002 FO

000001 T PIF.POLICY.NUMBER 000007 1234567

000001 F TOP INSURED

000001 F BILL INSURED

000001 F BILL.STUB220 INSURED

000001 E