I have masterfile with several joins and I get an error when I execute the fex against it. I have researched and checked several possible causes, but still get the error. The field in question is the same format as the join field in the parent. What's causing this error?

(FOC1131) INVALID FIELDNAME CO_NBR FOR IXFLD. EMP-VIEW LN 93

WF 5.3.3

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

You will probably need to provide the master and fex. Even better if you could reproduce the error on an IBI sample file such as CAR.

Remember, a particular error message can have many different causes and situations where it might occur. Someone here might be able to get a lucky guess to solve your issue, but better would be for you to start by providing the master and fex.

Error message:
(FOC1131) INVALID FIELDNAME PRISM_CO_NBR FOR IXFLD. EMP-VIEW LN 93
1
0 NUMBER OF RECORDS IN TABLE= 124459 LINES= 124459
0



Masterfile:

FILE=emp-view, SUFFIX=SQLORA
SEGNAME=EMPLOYEE, SEGTYPE=S0, $
FIELD=EMPLOYEE_NBR, ALIAS=EMPLOYEE_NBR, USAGE=P10, ACTUAL=P6, TITLE='Employee,Number', DESCRIPTION='10-character employee number', HELPMESSAGE='10-character employee number', $
FIELD=PRISM_CO_NBR, ALIAS=PRISM_CO_NBR, USAGE=P2, ACTUAL=P2, MISSING=ON, DESCRIPTION='PRISM Company Number', HELPMESSAGE='PRISM Company Number', $
.
.
.
.
SEGNAME=COMPANY, SEGTYPE=U, PARENT=EMPLOYEE, $
FIELD=PRISM_CO_NBR, ALIAS=PRISM_CO_NBR, USAGE=P2, ACTUAL=P2, MISSING=ON, DESCRIPTION='PRISM Company Number', HELPMESSAGE='PRISM Company Number', $
FIELD=COMPANY_DESC, ALIAS=COMPANY_DESC, USAGE=A50, ACTUAL=A50, $
FIELD=GEN_LED_CO_NBR, ALIAS=GEN_LED_CO_NBR, USAGE=A3, ACTUAL=A3, MISSING=ON, TITLE='General,Ledger,Company,Number', $
FIELD=HR_CO_NBR, ALIAS=HR_CO_NBR, USAGE=A2, ACTUAL=A2, MISSING=ON, $

Access File

SEGNAME=COMPANY,
KEYFLD=PRISM_CO_NBR,
TABLENAME=HR.COMPANY,
KEYS=1,
IXFLD=PRISM_CO_NBR,
CONNECTION=xxxxx,$

And what is the Master and Field on the othere side of the join ?

The error message refers to your foreign key, but your host key field, PRISM_CO_NBR, occurs twice in the EMP-VIEW master - once in the EMPLOYEE segment and again in the COMPANY segment. Maybe that is the problem.

Changed the alias to COMPANY_NBR in the COMPANY segment and didn't get the error. However, I had tried that before and still got an error. It's working now. Thanks, I appreciate all reponses.