REBUILD utility - error on input file - file not found

Problem:

You may be trying to do a very simple rebuild on a small ISAM file but for some reason the command is not finding the input file to be rebuilt (even though it is in the present working directory).

You may have been following the suggestions in the manual & it seems like it should work....

Resolution:

The first thing to consider is the way the file is named.

If it is FILENAME.dat and FILENAME.idx, then you are probably using the IDXNAMETYPE filehandler configuration option.

By default, the name of the data portion of the indexed will be exactly as specified in ASSIGN clause in the SELECT statement of the program. Therefore, if the program has ASSIGN "CCSTAT.dat", then the data part of the file would be CCSTAT.dat - however the indexed part of the file would be created as CCSTAT.dat.idx.

For you to have the file extensions as you have - CCSTAT.dat and CCSTAT.idx, you probably have the IDXNAMETYPE configuration option set to 2 in the filehandler config file (either extfh.cfg by default or a filename specified in the EXTFH environment variable).

Option 2 for IDXNAMETYPE automatically appends the data file with .dat and the index file with .idx. Therefore, if ASSIGN "CCSTAT" is in the SELECT statement then the file will be created as CCSTAT.dat and CCSTAT.idx  

If this has been set, then rebuild will read the file handler config file (eg extfh.cfg) and will make the same adjustment. Thus, if you type: rebuild CCSTAT.dat it will be looking for a file CCSTAT.dat.dat and CCSTAT.dat.idx.

So, if IDXNAMETYPE=2 has been set, you'd need to type the rebuild command as follows: rebuild CCSTAT -f:c8d1     and the .dat will automatically be added because rebuild will also look at the extfh.cfg file.