Informix standard engine

lokesh123 · Aug 14, 2002

I am using standard engine and while running a program with cursors, I am getting SQL error code 271.
I checked the error description but cudnt resolve it.
during the cursor run, out of the 248 records that its supposed to insert its inserting 212 and then it gives this error and exits the program.
Any advise?
thanks

lokesh123 · Aug 15, 2002

The ISAM error associated with that is 121, I checked the Log file and there is almost 80% free space. Still it says cannot write log record. Any idea what else could be the problem. This is very urgent. Thanks

olded · Aug 15, 2002

Lokesh:

Sorry, It's been years since I've used SE, but ...

As far as not being able to write to the log file. Have you made sure the user executing the program has write permissions on the log file? I don't mean to elaborate on the obvious.

Regards,

Ed

lokesh123 · Aug 16, 2002

Hi Thanks,
Actually it was the problem with the index file. I just had to rebuild the index and the problem got fixed.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Informix standard engine

lokesh123

Programmer

lokesh123

Programmer

olded

Programmer

lokesh123

Programmer

Similar threads

Part and Inventory Search

Sponsor