Re: Esql/c problem Error -242

On 5 Apr 1998 21:45:17 GMT, kponn@aol.com (KPonn) wrote: >Hello everyone, > >I have a running ESQL/C program that suddenly started crashing at the same >place in a report that it generates. SQLCODE = -242 and ISAM = -106.( After >doing some selects and inserts etc..., this program generates a report.) I >looked into the decriptions of these messages, I did not understand what "run >either bcheck or secheck on files" means. > >Can someone explain to me what's going on here.Thanks in advance for your help. -106 indicates that exclusive access is required for an operation and that it was not obtained prior to the operation. Most common cause is trying to drop a table or index where the table is being accessed by other users. To get it in a report is rather unusual. The bcheck message (I did not see such a message running finderr with version 7.24) indicates that an index might be corrupted. Bcheck can be used to detect such corruption and repair (actually rebuild) the index, if you are using the SE engine (secheck is the new name for bcheck). You don't mention which server version you are running (SE or IDS, and what version #). Such info would help in the formulation of a more complete answer. -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)