Well, I just tried this again, adding in a FILEDEF for good measure, and once again I get the vexing FOC36219 message.
But I did notice that the master file was created, so it half works.
Thanks for the idea. Keep 'em coming.
-James
>>!pwd
/focd01/users/muirj/extracts
>>APP LIST
BEGIN-APP-LIST
17/12/2003 15.28.16 session
23/01/2004 13.56.08 baseapp
23/01/2004 14.01.59 bchtest
11/03/2004 10.34.33 bchtst2
14/07/2004 14.11.41 cuwatest
01/07/2004 12.38.16 ibinccen
01/07/2004 12.17.17 ibisamp
14/07/2004 15.37.08 wdisk
16/07/2004 16.58.13 udisk
14/07/2004 14.53.08 sstest
16/07/2004 16.01.19 muirjwf
END-APP-LIST
>>APP SHOWPATH
muirjwf
wdisk
cuwatest
udisk
bchtest
ibisamp
baseapp
>>FILEDEF WALLY DISK /focd01/users/muirj/extracts/wally.ftm
>>APP MAP holddir /focd01/users/muirj/extracts
>>APP HOLD holddir
>>APP PREPENDPATH holddir
>>APP SHOWPATH
holddir
muirjwf
wdisk
cuwatest
udisk
bchtest
ibisamp
baseapp
>>EX USEIBI
>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE HOLD AS WALLY FORMAT ALPHA
>END
NUMBER OF RECORDS IN TABLE= 5 LINES= 5
(FOC36219) AN ERROR OCCURED WHEN OPENING FILE: WALLY
>>
>>!ls -lF /focd01/users/muirj/extracts
total 44
drwxr-x--- 2 muirj hdrstaff 1536 Jan 30 10:06 gen/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:35 gmc/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:37 gpa/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 08:54 hcl/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:25 hclw/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:34 hcs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 10:23 hpa/
drwxr-x--- 2 muirj hdrstaff 1024 Jul 19 13:19 mah/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:58 oprn/
drwxr-x--- 2 muirj hdrstaff 1024 Jun 25 10:51 phar/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 14:22 pnln/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 11:33 pnls/
drwxr-x--- 2 muirj hdrstaff 512 Jul 15 16:57 prn/
drwxr-x--- 2 muirj hdrstaff 512 Jul 7 16:25 prs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 09:31 ptdw/
drwxr-x--- 3 muirj hdrstaff 512 Jun 24 15:31 schn/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:33 schs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 14:22 spr/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 09:34 ucv/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:39 upa/
-rw-r----- 1 muirj hdrstaff 588 Jul 19 13:21 wally.mas
>>!cat wally.mas
$==================================================================$
$ HOLD file created on 2004/07/19 at 13.18.40 by FOCUS R720526B $
$ Database records retrieved= 5 $
$ Records in the HOLD file = 5 $
$==================================================================$
FILE=WALLY ,SUFFIX=FIX
SEGNAME=WALLY ,SEGTYPE=S0
FIELDNAME =COUNTRY ,E01 ,A10 ,A10 ,$