Hi,

  FILE=A,REMARK='STORE RETURNS', DATASET='//opt/webfocus/path/SR_Item.txt',
SEGNAME=ROOT_SEG, SEGTYPE=S0, $

FIELDNAME=ACCT_YR_I,ALIAS=ACCT_YR_I,USAGE=P5,  MISSING=OFF, $
FIELDNAME=ACCT_MO_I,ALIAS=ACCT_MO_I,USAGE=P3,  MISSING=OFF, $
FIELDNAME=f_FIN_ITEM_I,ALIAS=FIN_ITEM_I,USAGE=P11, MISSING=ON, $
FIELDNAME=f_FIN_VEND_I,ALIAS=FIN_VEND_I,USAGE=P11, MISSING=ON, $
FIELD=DELIMITER ,ALIAS='|' ,USAGE=A1  ,ACTUAL=A1  ,$

with the above code , i got the focerror
(FOC1272) DFIX: INCORRECT MFD ALIAS VALUE FOR NUMERIC DELIMITER

and i had incorporated the solution as well.

  
FILE=A,REMARK='STORE RETURNS', DATASET='//opt/webfocus/path/SR_Item.txt',
SEGNAME=ROOT_SEG, SEGTYPE=S0, $

SEGNAME=DSA_CLMANT_DIM_PIPE,DELIMITER=|, HEADER=NO, $
FIELDNAME=ACCT_YR_I,ALIAS=ACCT_YR_I,USAGE=P5,  MISSING=OFF, $
FIELDNAME=ACCT_MO_I,ALIAS=ACCT_MO_I,USAGE=P3,  MISSING=OFF, $
FIELDNAME=f_FIN_ITEM_I,ALIAS=FIN_ITEM_I,USAGE=P11, MISSING=ON, $
FIELDNAME=f_FIN_VEND_I,ALIAS=FIN_VEND_I,USAGE=P11, MISSING=ON, $
-*FIELD=DELIMITER ,ALIAS='|' ,USAGE=A1  ,ACTUAL=A1  ,$

i get the following error

  (FOC03601) ERROR AT OR NEAR LINE 3 IN PROCEDURE TXT_MASTERFINAL_ITEM
 (FOC1822) WARNING. INVALID SYMBOL: >DELIMITER<
 ----------------------------vvvvvvvvv
 SEGNAME=DSA_CLMANT_DIM_PIPE,DELIMITER=|, HEADER=NO, $
 BYPASSING TO END OF COMMAND

can u help me resolve this ?

Thanks!

This message has been edited. Last edited by: Kerry,

There's something wrong with your Master:

The FILE declaration must include the attribute "SUFFIX=DFIX", yours ends in a comma. I recommend ending the FILE declaration with a ", $".

The documentation specifies "REMARKS" and not "REMARK" as the attribute, but due to WebFOCUS's loose standards, this might be OK.

FILE=A, REMARKS='STORE RETURNS', DATASET='//opt/webfocus/path/SR_Item.txt', SUFFIX=DFIX, $
SEGNAME=ROOT_SEG, SEGTYPE=S0, $
...

FYI

Master file coding 101.

A comment is started with a '$' character, and not '-*'.

Hi,

Sorry for those.
Please find the below code after the changes , am still getting the error :

  
(FOC03601) ERROR AT OR NEAR LINE 3 IN PROCEDURE TXT_MASTERFINAL_ITEM
 (FOC1822) WARNING. INVALID SYMBOL: >DELIMITER<
 ----------------------------vvvvvvvvv
 SEGNAME=DSA_CLMANT_DIM_PIPE,DELIMITER=|, HEADER=NO, $


Master file description 

[CODE]  

FILE=randtst,SUFFIX=DFIX,REMARKS='STORE RETURNS', DATASET='//opt/webfocus/enterprise/adhoc/ibi/apps/ftptdrpt/SR_Item.txt',$
SEGNAME=ROOT_SEG, SEGTYPE=S0, $
SEGNAME=DSA_CLMANT_DIM_PIPE,DELIMITER=|, HEADER=NO, $
FIELDNAME=ACCT_YR_I,ALIAS=ACCT_YR_I,USAGE=P5,  MISSING=OFF, $
FIELDNAME=ACCT_MO_I,ALIAS=ACCT_MO_I,USAGE=P3,  MISSING=OFF, $
FIELDNAME=f_FIN_ITEM_I,ALIAS=FIN_ITEM_I,USAGE=P11, MISSING=ON, $
FIELDNAME=f_FIN_VEND_I,ALIAS=FIN_VEND_I,USAGE=P11, MISSING=ON, $

Thanks!

Please check out the documentation.

http://documentation.informati...g/source/topic65.htm

There are two ways to describe a pipe delimited file.

The first has a field at the end called delimiter.
The second has a specification of the delimiter in the access file.

All cases require the suffix of the master to be DFIX.

So, this would be correct (at least it does not give error messages when doing Check):

FILE=randtst,SUFFIX=DFIX,REMARKS='STORE RETURNS',DATASET=whatever,$
SEGNAME=ROOT_SEG, SEGTYPE=S0, $
FIELDNAME=ACCT_YR_I,ALIAS=ACCT_YR_I,USAGE=P5,  MISSING=OFF, $
FIELDNAME=ACCT_MO_I,ALIAS=ACCT_MO_I,USAGE=P3,  MISSING=OFF, $
FIELDNAME=f_FIN_ITEM_I,ALIAS=FIN_ITEM_I,USAGE=P11, MISSING=ON, $
FIELDNAME=f_FIN_VEND_I,ALIAS=FIN_VEND_I,USAGE=P11, MISSING=ON, $
FIELD=DELIMITER ,ALIAS='|' ,USAGE=A1  ,ACTUAL=A1  ,$