I am getting the above error after importing the CLSEXCL table to my metadata. I have lots of other tables I have joined in the same way without indexes. These are DB2 tables on an iSeries. When I brought the subject up at the Summit, it was suggested I change the index number from 0 to 1, but that didn't work. Any suggestions?

Code Example

Access File Text

SEGNAME=FFCCSTAP, TABLENAME=PWRDTA/FFCCSTAP, CONNECTION=ISERIES,
GUI_PARAMS='0,48,318,96,366,100,120,1', KEYS=0, $
SEGNAME=FFDCSTBP, TABLENAME=PWRDTA/FFDCSTBP, CONNECTION=ISERIES,
GUI_PARAMS='0,47,58,95,106,100,120,1', KEYS=0, $
SEGNAME=WBCSTXP, TABLENAME=PWRDTA/WBCSTXP, CONNECTION=ISERIES,
GUI_PARAMS='0,46,192,94,240,100,120,1', KEYS=0, $
SEGNAME=CLSEXCL, TABLENAME=PWRDTA/CLSEXCL, CONNECTION=ISERIES,
GUI_PARAMS='0,115,406,163,454,100,120,1', KEYS=0, $


Text View

FILENAME=customer_master, SUFFIX=DB2 ,
REMARKS='F/M Customer Master File -Physical File', $
SEGMENT=FFCCSTAP, SEGTYPE=S0, $
FIELDNAME=FFCCMPN, ALIAS=FFCCMPN, USAGE=A3, ACTUAL=A3,
TITLE='Company number', DESCRIPTION='Company number', $
FIELDNAME=FFCCUSN, ALIAS=FFCCUSN, USAGE=A10, ACTUAL=A10,
TITLE='Customer Number', DESCRIPTION='Customer number', $
FIELDNAME=FFCCNMB, ALIAS=FFCCNMB, USAGE=A25, ACTUAL=A25,
TITLE='Customer Name', DESCRIPTION='Customer name', $
SEGMENT=CLSEXCL, SEGTYPE=U, PARENT=FFCCSTAP, CRJOINTYPE=INNER,
JOIN_WHERE=SUBSTR(10, FFCCUSN, 6, 10, 5, 'A5') EQ CLSCUS;, $
FIELDNAME=CLSCUS, ALIAS=CLSCUS, USAGE=A5, ACTUAL=A5,
TITLE='CUSTOMER NUMBER', DESCRIPTION='CUSTOMER NUMBER', $
FIELDNAME=CLSCLS, ALIAS=CLSCLS, USAGE=A3, ACTUAL=A3,
TITLE='CLASS NUMBER', DESCRIPTION='CLASS NUMBER', $

This message has been edited. Last edited by: Jay Potter,

we have had this a few days ago

what we did is rebuild the whole master and access file from the server again
it is the fastest way

I will try that, but it would be nice to know what causes it.