In this blog post, let’s learn about the error message “011 No more processes.” in Hydra and the description of the error. Error Message 011 No more processes. Error Details Your application could not start a database server process or could not create a process that some subordinate function such as a REPORT TO pipe or a network-access program needed. This error probably reflects a…

In this blog post, let’s learn about the error message “292 An implied insert column column-name does not accept NULLs.” in Hydra and the description of the error. Error Message 292 An implied insert column column-name does not accept NULLs. Error Details This statement attempts to update with a cursor that was not declared for update. The database server does not allow this action, as…

In this blog post, let’s learn about the error message “230 Could not read a temporary file.” in Hydra and the description of the error. Error Message 230 Could not read a temporary file. Error Details This statement names the column ROWID in the list of columns for insertion or update. The row ID is an intrinsic property that cannot be modified. You can select…

In this blog post, let’s learn about the error message “281 Could not add index to a temporary table.” in Hydra and the description of the error. Error Message 281 Could not add index to a temporary table. Error Details This statement names one or more of the database-level privileges (CONNECT, RESOURCE, and DBA), but it also uses the ON table-name clause. A statement that…

In this blog post, let’s learn about the error message “001 Not owner.” in Hydra and the description of the error. Error Message 001 Not owner. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Check the ownership and permissions of files and directories that are used in the current operation. Look for other operating-system error messages…

In this blog post, let’s learn about the error message “006 No such device or address.” in Hydra and the description of the error. Error Message 006 No such device or address. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. You might have made an error when you configured the database software or in the REPORT…

In this blog post, let’s learn about the error message “067 Too many processes.” in Hydra and the description of the error. Error Message 067 Too many processes. Error Details Your application was unable to start a database server process or was unable to create a process that was needed for some subordinate function such as a REPORT TO pipe or a network-access program. This…

In this blog post, let’s learn about the error message “020 Not a directory.” in Hydra and the description of the error. Error Message 020 Not a directory. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information. Some database servers store databases as directories that are…

In this blog post, let’s learn about the error message “222 Cannot write to temporary file for new table table-name.” in Hydra and the description of the error. Error Message 222 Cannot write to temporary file for new table table-name. Error Details Every SELECT statement must include a FROM clause to name the table or tables that it queries. Check that FROM was spelled and…

In this blog post, let’s learn about the error message “190 ISAM error: Transaction table overflow.” in Hydra and the description of the error. Error Message 190 ISAM error: Transaction table overflow. Error Details If this internal error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “066 Directory not empty.” in Hydra and the description of the error. Error Message 066 Directory not empty. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information, particularly what directory was being removed. If the error…

In this blog post, let’s learn about the error message “002 No such file or directory.” in Hydra and the description of the error. Error Message 002 No such file or directory. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information.

In this blog post, let’s learn about the error message “008 Exec format error.” in Hydra and the description of the error. Error Message 008 Exec format error. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information. If the error recurs, please note all circumstances and…

In this blog post, let’s learn about the error message “362 Can have only one column of serial/serial8 type.” in Hydra and the description of the error. Error Message 362 Can have only one column of serial/serial8 type. Error Details A table can have at most only one column of type SERIAL and one column of type SERIAL8. You are attempting to add a second…

In this blog post, let’s learn about the error message “256 Transaction not available.” in Hydra and the description of the error. Error Message 256 Transaction not available. Error Details The number of host variables that you named in the INTO clause of this statement does not match the number of columns that you referenced in the statement. Locate the text of the statement (in…

In this blog post, let’s learn about the error message “259 Cursor not open.” in Hydra and the description of the error. Error Message 259 Cursor not open. Error Details The database server can handle only a fixed number of prepared SQL statements for each user. This limit includes statements that were prepared with the PREPARE statement and cursors that were declared with the DECLARE…

In this blog post, let’s learn about the error message “175 ISAM error: An error has occurred during physical restore.” in Hydra and the description of the error. Error Message 175 ISAM error: An error has occurred during physical restore. Error Details This generic message indicates that the archive backup has failed. The SQL API also contains useful error text that is associated with this…

In this blog post, let’s learn about the error message “010 No children.” in Hydra and the description of the error. Error Message 010 No children. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information. If the error recurs, please note all circumstances and contact Informix…

In this blog post, let’s learn about the error message “114 ISAM error: the file name is too long.” in Hydra and the description of the error. Error Message 114 ISAM error: the file name is too long. Error Details Another user request has opened the file (table) that was requested in exclusive mode. In systems that use files for locking, a tablename.lok file exists….

In this blog post, let’s learn about the error message “374 Can only use column number in ORDER BY clause with UNION.” in Hydra and the description of the error. Error Message 374 Can only use column number in ORDER BY clause with UNION. Error Details This query has both a UNION clause and an ORDER BY clause. In a union query, in which multiple…