Article - CS89405
SQL CREATE long name; rename to short name syntax in Implementer
Modified: 08-Jun-2022
Applies To
- Implementer 11.0 to 12.5
Description
- Promoting SQL table, view, or index using rename syntax of
- CREATE <longname>;
- RENAME <longname> TO SYSTEM NAME <shortname>;
- Compile may succeed on Workbench, but promotion job fails with one or more of the following
- CPF3204 Cannot find object needed for file <file name> in <Implementer work library> when restoring on receiver
- CPF9812 File <file name> in <Implementer work library> not found when promoting on host
- VIM4328 Error in request <request ID>, environment <target environment> due to database relations outside of <Implementer work library> library for file <file name>
- Promoting SQL file CREATE statement with CONSTRAINT ... REFERENCING <longname> when the referenced <longname> was not created with a short name fails with SQL0204 "<longname> in <ImplementerWorkLib> type *FILE not found."
- Job log shows variations of error messages that do not relate to the root cause such as:
- VIM4109 Physical file TRIGGER for logical file INT062G001 was not found in the CPUQAC environment library list.
- Cause was SQL CREATE TABLE <longname> in INT062T source member, and INT062G001 source referenced the <longname>
- VIM4109 Physical file TRIGGER for logical file INT062G001 was not found in the CPUQAC environment library list.
- Job log shows variations of error messages that do not relate to the root cause such as:
This is a printer-friendly version of Article 89405 and may be out of date. For the latest version click CS89405