Informix Error -29031: Table or view name objname has an invalid format

Cause and resolution

Table or view name objname has an invalid format

The Add-table and Purge-table options of the gwdba utility for adding and purging tables and views from the Informix catalog on an application server require a file of table and view names as input. The listed table or view name (objname) has an invalid format. The format of table and view names in the file must be in the following format:

owner.tabname

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29031 fires when the gwdba utility's Add-table/Purge-table input file lists a table or view name in the wrong format — per the official guidance, entries must be in the form owner.tabname.

A table/view name in the gwdba input file not matching owner.tabname, per the official guidance — the direct, only cause.

Solutions / Resolution

Correct the entry in the input file to the owner.tabname format, per the official guidance.

Examples

Correct table-name format

informix.orders

Diagnostic Checks

Check every entry in the gwdba Add-table/Purge-table input file for the owner.tabname format.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -29031 in this set yet.

A gwdba Add-table/Purge-table input file entry wasn't in owner.tabname format — correct it.