Informix Error Messages and Error Codes From Error 298 to 302


Informix Error Code -298 Cannot grant permission to public with grant option.
The clause WITH GRANT OPTION allows the receiver of the grant to grant the same privilege to others. In this case, the receiver of the grant is PUBLIC. If this statement were executed, everyone would have the privilege, and everyone could grant the privilege. This operation is prohibited. Either name specific grantees, or omit the clause WITH GRANT OPTION.
Informix Error Code -299 Cannot grant permission to self.
This GRANT statement includes your user id as one of the grantees. If you can grant the privilege, you already have the privilege. Rewrite the statement to omit your user name from the TO clause.

Informix Error Code -300 There are too many GROUP BY columns.
The number of columns that can be listed in the GROUP BY clause is an implementation limit of the database server. All database servers support at least eight columns. Review the current statement to ensure that the punctuation of the GROUP BY clause is correct. If it is as you intended, you will have to find a way to make this query in two or more stages. Since you must list all nonaggregate selected columns in the GROUP BY clause, and the length of the list is restricted, you must select only the non-aggregate values that are required to distinguish each group. Put the group results in a temporary table, and join this table to the original table to select other non-aggregate values.

Informix Error Code -301 The total size of the GROUP BY columns is too big.
The database server limits the total number of bytes in the combined columns that the GROUP BY clause lists. All database servers support at least 120 bytes. See the discussion of error -300 for more information.
Informix Error Code -302 No GRANT option or illegal option on multi-table view.
This GRANT statement cannot be executed. You do not have the right to grant the specified privilege for this table, the table name is a synonym, or the table is a view on which this option cannot be granted. To grant any privilege for a table, you must have DBA privilege in this database, you must be the owner of the table, or you must have been granted the same privilege WITH GRANT OPTION. If one of these conditions is true, probably the table in question is really a synonym or a view that is not modifiable and cannot be used for insert, update, or delete operations.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *