Someone asked the question above and the Veryant support engineer answered as follows:
The problem is in the lines:
100008 RECORD KEY IS FILE1-KEY
100009 ALTERNATE RECORD KEY IS FILE1-KEY,
You have defined the alternate key to be the same as the primary key. If you comment out the ALTERNATE line then you will no longer get the error.
The way I diagnosed this was to run the program with the following properties:
I then noticed in the log.txt file the following:
Oct 28, 2010 220.127.116.119 INFO: Unknown error FILE1 (FILE1.DAT) FS=[9l],EXFS=: unknown error
So the 91,10 is actually a 91,108
I then checked our KB for how to diagnose 9? errors and in the article How do I interpret file status 9? and other EXFS extended file status codes (e.g. 9i,105)? I found the following:
static final int E_IO_KEXISTS = 108; /* key already exists */
which told me that the OPEN was trying to add a key that was already added. I then looked at the SELECT and found the problem.