BUILD.FILE
Use BUILD.FILE to extract data to create a flat file of data. This data can be
output to a specific directory (i.e. _HOLD_) in either fixed width or using a
delimiter (i.e. comma or pipe symbol). Data locations will be specified by
either indicating the file name and locations (i.e. attribute, multivalue,
subvalue) or using established dictionaries.
CUNAME BUILD.FILE BUILD A FLAT FILE FOR DOWNLOAD
0= Enter Table ID MBR.MAILING
1= Table applicable 1 Other
2. Description MAILING TO ALL MBRS
3. Directory file to write data to _HOLD_
4. Item ID to write data to MBR.MAILING
5. Field Delimiter ,
6. SELECT, SSELECT or GET-LIST statement
SELECT CLIENT WITH S1 GE "5.00"
7. =Data location =Conversion
Justification
1 @ID
N/A
2 CLIENT<7>
3 CLIENT<1>
4 CLIENT<2,1>
5 CLIENT<2,2>
6 CLIENT<2,3>
7 CLIENT<2,4>
8 CLIENT<2,5>
9 CLIENT<2,6>
Enter Field number, Field Range, ALL, Delete, Create data or Save
CUNAME BUILD.FILE BUILD A FLAT FILE FOR DOWNLOAD
0= Enter Table ID CAR.SALE
1= Table applicable 1 Other
2. Description CAR SALE IN MAY 2009
3. Directory file to write data to BUILDFILE
4. Item ID to write data to
CAR.SALE
5. Field Delimiter
6. SELECT, SSELECT or GET-LIST statement
GET-LIST CAR.SALE
7. =Data location =Conversion
Justification
1 CLIENT<7>
L#30
2 CLIENT<1>
L#45
3 CLIENT!ACT.ADDR1
L#45
4 CLIENT!ACT.ADDR2
L#45
5 CLIENT!ACT.CITY
L#30
6 CLIENT!ACT.STATE
L#2
7 CLIENT!ACT.ZIP
R#10
Enter Field number, Field Range, ALL, Delete, Create data or Save