PROBLEM

SDE for Informix: Cannot create same-name layers in different databases

Last Published: April 25, 2020

Solution or Workaround

Problem:

SDE for Informix administration commands can use the -D option to select a database in which a layer is stored and retrieved. However, another layer with the same name and owner cannot be created, even if it is to reside in a different Informix database on the same Informix server.

Cause:

Though the database name is stored correctly in the "f_table_catalog" column of both SDE.LAYERS and SDE.GEOMETRY_COLUMNS, it is not being used to differentiate between layers correctly.

Solution:

Create same-name tables in different Informix databases using different owner names.

This is a known problem.

Article ID:000001885

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic