Informix Error Messages and Error Codes From Error 6031 to 6037

SQLServerF1

Informix Error Code -6031 The user does not have SQL permission to SELECT the specified columns.
The user account that is running this program has not been granted SELECT privilege on the current table or on the particular columns that are being selected. A user with DBA privileges for the database should use the SQL statement GRANT to grant the necessary privilege. Then run the program again.
Informix Error Code -6032 The user does not have SQL permission to INSERT rows into the table.
The user account that is running this program has not been granted INSERT privilege on the current table. A user with DBA privileges for the database should use the SQL statement GRANT to grant the necessary privilege. Then run the program again.

Informix Error Code -6033 The user does not have SQL permission to UPDATE the specified columns.
The user account that is running this program has not been granted UPDATE privilege on the current table. A user with DBA privileges for the database should use the SQL statement GRANT to grant the necessary privilege. Then run the program again.
Informix Error Code -6034 The user does not have SQL permission to DELETE rows from the table.
The user account that is running this program has not been granted DELETE privilege on the current table. A user with DBA privileges for the database should use the SQL statement GRANT to grant the necessary privilege. Then run the program again.

Informix Error Code -6035 No current row.
The flag parameter passed to dbfind() implies a current row (for example, a flag of CURRENT or NEXT as opposed to one of FIRST); however, a prior call has not established a current row. Review the program logic to make sure that it establishes a current row before it makes a call of this kind.
Informix Error Code -6036 An aliasname is the same as an existing table name within the database.
The newname parameter that was given to dbalias() already exists as a table in the database. Review the program logic, and change it to use only unique aliases.
Informix Error Code -6037 An aliasname has been used previously.
The newname parameter that was given to dbalias() has already been defined as an alias in a previous call. An alias can be defined only once in the run of a program. Review the program logic, and change it to use aliases only once.

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.

Thanks,
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 *