Today seems to be the day for JOIN questions...

I have two flat files:

FILENAME=mailfile, SUFFIX=COM     ,                 
 DATASET=FILEPATH/MAILFILE.TXT, $                      
  SEGMENT=MYMAIL, SEGTYPE=S1, $                   
    FIELDNAME=LISTCD, ALIAS=LISTCD, USAGE=A5, $     
    FIELDNAME=LISTDESC, ALIAS=LISTDESC, USAGE=A50, $
    FIELDNAME=MAILQTY, ALIAS=MAILQTY, USAGE=A8, $

FILENAME=mstrfile, SUFFIX=FIX     ,                                  
 DATASET=MAIN.FRAME.DATASET.NAME, $                               
  SEGMENT=SEG01, SEGTYPE=S0, $                                       
    FIELDNAME=PHNBR, USAGE=A9, ACTUAL=A9,                            
      TITLE='PHONE NUMBER', DESCRIPTION='PHONE NUMBER', $            
    FIELDNAME=ADDRFLAG, USAGE=A1, ACTUAL=A1,                         
      TITLE='ADDRESS FLAG', DESCRIPTION='ADDRESS FLAG', $            
    FIELDNAME=EMAILFLG, USAGE=A1, ACTUAL=A1,                         
      TITLE='EMAIL ADDRESS FLAG', DESCRIPTION='EMAIL ADDRESS FLAG', $
    FIELDNAME=DECFLAG, USAGE=A1, ACTUAL=A1,                          
      TITLE='DECEASED FLAG', DESCRIPTION='DECEASED FLAG', $          
    FIELDNAME=RESPDATE, USAGE=A8, ACTUAL=A8,               
      TITLE='RESPONSE DATE', DESCRIPTION='RESPONSE DATE', $
    FIELDNAME=SRCCODE, USAGE=A5, ACTUAL=A5,                      
      TITLE='SOURCE LIST CODE', DESCRIPTION='SOURCE LIST CODE', $

Using the Join Editor, I get the following text:

JOIN
 INNER MAILFILE.MYMAIL.LISTCD IN MAILFILE TO MULTIPLE MSTRFILE.SEG01.SRCCODE
 IN MSTRFILE AS J0
 END

To this point, everything is fine. I then used the join in a report (via Report Assistant in Dev Studio). However when I run the report, I get the following error:

(FOC1101) THIS INTERFACE DOES NOT SUPPORT THE GLOBAL JOIN

Any idea why I would be getting this error?

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

I would first check to see if the files are sorted by the keyfields.

I believe it has to do with joining a comma delimited file to a fixed file. therefore just change the second file to a focus file and then do the join.

TABLE FILE MSTRFILE
PRINT *
BY SRCCODE NOPRINT
ON TABLE HOLD AS NEWMSTR FORMAT FOCUS INDEX SRCCODE
END

JOIN
INNER MAILFILE.MYMAIL.LISTCD IN MAILFILE TO MULTIPLE SRCCODE
IN NEWMSTR AS J0
END

OK, huge rookie mistake on the sorting of the files. I knew one of them was sorted correctly, but the other was not. This fixed my problem! Thanks Anatess!

mrguru, I am positive your input will be useful down the road as I have much to learn...