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
© Copyright 2012, Oracle and/or its affiliates. All rights reserved. Legal notices.