Informix Error -6036: An aliasname is the same as an existing table name within the database.
Cause and resolution
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.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-6036 fires when dbalias()'s newname parameter already exists as a real table name in the
database — per the archived catalogue.
- A proposed alias name colliding with an existing table name, per the archived catalogue — the direct, only cause.
Solutions / Resolution
- Use only unique alias names, per the archived catalogue, that don't collide with real table names.
Examples
N/A
No specific triggering statement is documented beyond the function-level condition described above.
Diagnostic Checks
- Check whether the proposed alias name already names a real table.
Related Errors / Related Topics
- -6037 — "An aliasname has been used previously."
- -6038 — "An alias cannot be an alias of an existing alias."
- -6040 — "The aliased table was not found as a table name in the database."
An alias name collided with a real table name — choose a genuinely unique alias.