Informix Error Messages and Error Codes From Error 16401 to 19804


Informix Error Code -16401 No program loaded.
A program was unloaded with the command UNLOAD PROGRAM, but no program was subsequently loaded with the command LOAD PROGRAM.
Informix Error Code -19800 Role name already exists as a user or role.
You cannot create a role name identical to any user that is known to the system or a user or role that is known to the database. Change the name of the role.

Informix Error Code -19801 Role name cannot be .
You cannot create a role name that is a reserved word. The reserved words are connect, resource, dba, select, update, delete, insert, index, references, alter, execute, default, none, null, and public. Change the name of the role.

Informix Error Code -19802 Name cannot appear as both the role granted and the role grantee.
A role cannot be granted to itself, either directly or indirectly. Verify if the role granted and grantee are the correct roles. Check for roles already granted to the role that is being granted.
Informix Error Code -19803 Only the DBA, or a user granted the role with the WITH GRANT OPTION can grant, revoke, or drop a role.
Check your privileges and permissions. To grant, revoke, or drop a role, you must be the DBA or have been granted the role with the WITH GRANT option.
Informix Error Code -19804 The role does not exist.
For a role to exist, the DBA must first use the CREATE ROLE statement to create the role. For a list of roles, see the informix.sysusers table.

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 *