Delimiter issue

[rummage]

Hi,

I am trying to read a text file. The textfile has a delimiter character '|'.
I created the .MAS file like the following

FILE=FLATFILE2, SUFFIX=DFIX, REMARK='First Flat File',
DATASET='c:\FlatFileData.txt'
SEGNAME=ROOT_SEG, SEGTYPE=S1, $
FIELD=ColumnName1, ALIAS=ColumnName1, USAGE=A12, ACTUAL=A12, $
FIELD=ColumnName2, ALIAS=ColumnName2, USAGE=A12, ACTUAL=A12, $
FIELD=DELIMITER, ALIAS='|', USAGE=A1, ACTUAL=A1, $

My FEX procedure is the following

FILEDEF FLATFILE2 DISK c:\FlatFileData.txt
TABLE FILE FLATFILE2
PRINT ColumnName1 ColumnName2
END

But when I run the FEX procedure, it gives me the following error:

(FOC1201) ERROR LOADING MODULE : DFIX
(FOC1074) INVALID SUFFIX : DFIX
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0


How do I fix it?

Thanks
Thambaiya

 

[focwizard]

From the error message, it sounds like you're using a release of WebFocus, BEFORE SUFFIX of DFIX was supported. What release are you using (type ? REL in an adhoc window to find what release of the server you have).

 

[FrankExp]

Change the word DFIX in FIX in your master. It is the option chosen after SUFFIX=
What focus does is opening the file by use of the loading module name after suffix.

Frank van de Kant

http://www.explicit.nl