In this blog post, let’s learn about the error message “235 Character column size is too big.” in Hydra and the description of the error. Error Message 235 Character column size is too big. Error Details Another user has locked a row that this statement selects. If you executed the statement interactively, you can do one of two things. You can wait a short time…

In this blog post, let’s learn about the error message “045 Operation not supported on socket.” in Hydra and the description of the error. Error Message 045 Operation not supported on socket. 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 circumstance, and contact Informix Technical Support.

In this blog post, let’s learn about the error message “328 Column column-name already exists in table.” in Hydra and the description of the error. Error Message 328 Column column-name already exists in table. Error Details This statement tries to add the column shown, but one with that name already exists. Check the spelling of the name; if it is as you intended, then the…

In this blog post, let’s learn about the error message “376 Log file already exists.” in Hydra and the description of the error. Error Message 376 Log file already exists. Error Details The transaction log file you specify in the WITH LOG IN clause must not already exist. The database server must start a log file fresh; it has no means of appending log data…

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

In this blog post, let’s learn about the error message “315 No create index permission.” in Hydra and the description of the error. Error Message 315 No create index permission. Error Details This statement tries to create an index for a table. Either you do not have INDEX privilege on this table, or the table itself is a view or synonym. If the table that…

In this blog post, let’s learn about the error message “206 The specified table is not in the database.” in Hydra and the description of the error. Error Message 206 The specified table is not in the database. Error Details The keyword ROWID stands for a virtual column that exists only in simple tables. This message refers to the ROWID of a table that is…

In this blog post, let’s learn about the error message “294 The column column-name must be in the GROUP BY list.” in Hydra and the description of the error. Error Message 294 The column column-name must be in the GROUP BY list. Error Details This INSERT statement does not supply values for all the columns in the table. At least one of the columns that…

In this blog post, let’s learn about the error message “280 A quoted string exceeds 256 bytes.” in Hydra and the description of the error. Error Message 280 A quoted string exceeds 256 bytes. Error Details This SELECT statement calls for ordering on more columns than the database server can support. The limit depends on the database server in use, but all can handle sorting…

In this blog post, let’s learn about the error message “141 ISAM error: tblspace table overflow.” in Hydra and the description of the error. Error Message 141 ISAM error: tblspace table overflow. Error Details The database server administrator sees this error. The database server is configured to handle a certain number of logical logs. The limit has been reached, so a log could not be…

In this blog post, let’s learn about the error message “246 Could not do an indexed read to get the next row.” in Hydra and the description of the error. Error Message 246 Could not do an indexed read to get the next row. Error Details The database server cannot read the disk page that contains a row of a table. Check the accompanying ISAM…

In this blog post, let’s learn about the error message “071 Too many levels of remote in path.” in Hydra and the description of the error. Error Message 071 Too many levels of remote in path. 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…

In this blog post, let’s learn about the error message “131 ISAM error: no free disk space.” in Hydra and the description of the error. Error Message 131 ISAM error: no free disk space. Error Details This code indicates one of two problems. The most likely problem is that this operation specifies a dbspace by name (for example, in the IN clause of a CREATE…

In this blog post, let’s learn about the error message “139 ISAM error: logfile table overflow.” in Hydra and the description of the error. Error Message 139 ISAM error: logfile table overflow. Error Details The database system administrator sees this error message. The database server is configured to handle a certain number of disk chunks. The limit has been reached, so a chunk could not…

In this blog post, let’s learn about the error message “115 ISAM error: cannot create lock file.” in Hydra and the description of the error. Error Message 115 ISAM error: cannot create lock file. Error Details The ISAM processor has been asked to open or create a file with a filename longer than 10 characters. For C-ISAM programs, this length exceeds the maximum for the…

In this blog post, let’s learn about the error message “229 Could not open or create a temporary file.” in Hydra and the description of the error. Error Message 229 Could not open or create a temporary file. Error Details This statement attempts to change the column named ROWID. That column is a part of every table except a fragmented table. You can select it…

In this blog post, let’s learn about the error message “013 Permission denied.” in Hydra and the description of the error. Error Message 013 Permission denied. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. This error code usually follows an attempt to execute a file that is not a program or shell script; it might reflect…

In this blog post, let’s learn about the error message “317 Must have the same number of selected columns in each UNION element.” in Hydra and the description of the error. Error Message 317 Must have the same number of selected columns in each UNION element. Error Details All rows that are produced in a union must have the same format, so each SELECT statement…

In this blog post, let’s learn about the error message “213 Statement interrupted by user.” in Hydra and the description of the error. Error Message 213 Statement interrupted by user. Error Details Other statements might be partially complete before the error is detected. Roll back the current transaction and then investigate the cause of the error. Use the oncheck utility (secheck with INFORMIX-SE or tbcheck…

In this blog post, let’s learn about the error message “393” in Hydra and the description of the error. Error Message 393 Error Details The named view cannot be dropped as it does not exist. To see names of existing views, query systables as follows: SELECT tabname FROM systables WHERE tabtype = ‘V’ The where clause contains an outer cartesian product. This query requests an…