INFORMIX 106-229 ERRORS (TEMPORARY TABLE)

Does anyone have a remedy or suggestion to solve sporadic 106 (non-exclusive access) errors followed immediately by 229 errors (Could not open temporary file) ??? We are running Informix Online 4.10 under HP9000 HP-UX Release 8.0. The same problem exists on Online 4.10 under a Pyramid. The net effect is that the 4GL program aborts. Most times the errors clear up automatically. The worst-case requires the Online to be stopped and restarted. Several application-specific changes have been made in our 4GL programs (closing cursors, freeing resources) with no success. The sequence of 4GL statements are: 1.) Display Window with Form 2.) Construct Query 3.) Prepare statement (Uses order by) 4.) Declare Scroll Cursor (Not declared update) 5.) Foreach --- End Foreach { To count records} 6.) Close cursor 7.) Open cursor 8.) Fetch first record 9.) CASE U Update N Next P Previous R Remove E Exit END CASE 10.) Close cursor 11.) free statement Thank you any assistance you can provide on this problem. Joseph Bell jbell.cbnewsk.att.com (404) 750-7396