Informix Error -6037: An aliasname has been used previously.
Cause and resolution
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.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-6037 fires when dbalias()'s newname parameter was already defined as an alias earlier in
the same program run — per the archived catalogue, an alias can be defined only once per run.
- The same alias name defined a second time in one program run, per the archived catalogue — the direct, only cause.
Solutions / Resolution
- Use each alias name only once per program run, per the archived catalogue.
Examples
N/A
No specific triggering statement is documented beyond the function-level condition described above.
Diagnostic Checks
- Check whether the program defines the same alias name more than once.
Related Errors / Related Topics
- -6036 — "An aliasname is the same as an existing table name within the database."
- -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."
The same alias defined twice in one run — each alias name may be defined only once.