In this blog post, let’s learn about the error message “227 DDL operations on ROWID prohibited.” in Hydra and the description of the error. Error Message 227 DDL operations on ROWID prohibited. Error Details The database server is trying to create one of the tables for the system catalog, probably as part of a CREATE DATABASE statement. A problem with the host operating system prevents…

In this blog post, let’s learn about the error message “039 Destination address required.” in Hydra and the description of the error. Error Message 039 Destination address required. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “162 ISAM error: Storage space does not exist.” in Hydra and the description of the error. Error Message 162 ISAM error: Storage space does not exist. Error Details This internal error should not occur. The database server has called a TEXT or BYTE function without first calling isbopen. If the error recurs, please note all…

In this blog post, let’s learn about the error message “318 File with the same name as specified log file already exists.” in Hydra and the description of the error. Error Message 318 File with the same name as specified log file already exists. Error Details The transaction log file you specify in the WITH LOG IN clause cannot already exist. The database server must…

In this blog post, let’s learn about the error message “262 There is no current cursor.” in Hydra and the description of the error. Error Message 262 There is no current cursor. Error Details Although you can prepare a SELECT statement, the only way you can then execute that SELECT statement is to associate its statement id with a cursor (use a DECLARE statement) and…

In this blog post, let’s learn about the error message “385 Data value out of range.” in Hydra and the description of the error. Error Message 385 Data value out of range. Error Details This statement attempts to put data into a view that was defined WITH CHECK OPTION, so new data has to satisfy the tests in the WHERE clause in the view. However,…

In this blog post, let’s learn about the error message “205 Cannot use ROWID for views with aggregates, group by or on multiple tables.” in Hydra and the description of the error. Error Message 205 Cannot use ROWID for views with aggregates, group by or on multiple tables. Error Details A numeric constant that is punctuated like a floating-point number (with a decimal point and/or…

In this blog post, let’s learn about the error message “191 ISAM error: No such chunk.” in Hydra and the description of the error. Error Message 191 ISAM error: No such chunk. Error Details Informix limits the number of outstanding in-place ALTER TABLE requests to 255. A 256th in-place alter of a table was requested before the completion of the first in-place alter. Completion means…

In this blog post, let’s learn about the error message “291 Cannot change lock mode of table.” in Hydra and the description of the error. Error Message 291 Cannot change lock mode of table. Error Details The table is already locked in exclusive mode. You will have to wait for the table to be unlocked before you proceed.

In this blog post, let’s learn about the error message “035 Operation would block.” in Hydra and the description of the error. Error Message 035 Operation would block. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “276 Cursor not found.” in Hydra and the description of the error. Error Message 276 Cursor not found. Error Details The person who created this table has not granted Delete privilege to your account name or to the public. The owner of the table or the DBA must grant this privilege before you can delete…

In this blog post, let’s learn about the error message “105 ISAM error: bad ISAM file format.” in Hydra and the description of the error. Error Message 105 ISAM error: bad ISAM file format. Error Details The ISAM processor has reached its limit of open files. For C-ISAM programs, review the program logic and change it so that fewer files are open concurrently. Use isclose…

In this blog post, let’s learn about the error message “322 Cannot create a trigger on, alter, rename view view-name.” in Hydra and the description of the error. Error Message 322 Cannot create a trigger on, alter, rename view view-name. Error Details Starting with version 9.40, you can only create an INSTEAD OF trigger on a view. You cannot create an INSTEAD OF trigger on…

In this blog post, let’s learn about the error message “219 Wildcard matching may not be used with non-character types.” in Hydra and the description of the error. Error Message 219 Wildcard matching may not be used with non-character types. Error Details (or SLV is undefined). The name appears in the select list or WHERE clause of this query but is not defined in a…

In this blog post, let’s learn about the error message “284 A subquery has returned not exactly one row.” in Hydra and the description of the error. Error Message 284 A subquery has returned not exactly one row. Error Details Inspect the current statement, examining the punctuation of all quoted strings. To include the quote character in a literal string, use single apostrophes as string…

In this blog post, let’s learn about the error message “231 Cannot perform aggregate function with distinct on expression.” in Hydra and the description of the error. Error Message 231 Cannot perform aggregate function with distinct on expression. Error Details The database server cannot create a temporary disk file. The file should be created in the directory that the DBTEMP environment variable specifies (or /tmp…

In this blog post, let’s learn about the error message “003 No such process.” in Hydra and the description of the error. Error Message 003 No such process. 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 “306 Subscript out of range.” in Hydra and the description of the error. Error Message 306 Subscript out of range. Error Details This statement refers to a substring of a character variable. The substring values (two numbers in square brackets) are incorrect. The first is less than zero or greater than the length of the…

In this blog post, let’s learn about the error message “005 I/O error.” in Hydra and the description of the error. Error Message 005 I/O 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. In particular, try to determine what device produced the error and…

In this blog post, let’s learn about the error message “232 A SERIAL column column-name may not be updated.” in Hydra and the description of the error. Error Message 232 A SERIAL column column-name may not be updated. Error Details The database server created a temporary file in the directory specified by the DBTEMP environment variable (or /tmp by default on UNIX systems) but encountered…