Re: sql question

The error message sail it all. The server process has been terminated by whatever reasons, this has nothing to do with your SQL statement. Try to find out what happened on the server. Here is the error message for 457 : -457 SQL engine terminated unexpectedly. The database server process with which your application program was working has terminated. If it was INFORMIX-OnLine, the OnLine administrator may have shut the system down. If it was INFORMIX-SE, it is possible that the database server process was terminated deliberately using an operating system command. If a deliberate shutdown was not done, the next most likely cause is an internal error. The current transaction should be rolled back automatically when the database is next opened. Look for operating system messages that might give more information. If the problem recurs, please note all circumstances and contact the Informix Technical Support Department. Note: Be sure to check the ISAM error code returned with this error. If it is -129, the database server has not terminated, but simply reached a limit on the number of concurrent user sessions (see the explanation of error -129). Hope this help. ------------------------------------------------------------------------------- Richard Jen MIS Sr. Programmer/DBA ssjen@iphase.com Interphase Corp. 13800 Senlac Drive TEL : (214) 919-9305 Dallas, TX 75234 FAX : (214) 919-9200 -------------------------------------------------------------------------------