NIM035936 for No Product Found

Bug ID Number	NIM035936
Submitted	June 6, 2008
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	9.3
Version Fixed	9.4
Status	Fixed

Description

** Internal Publish Only! This article may contain information that is not intended for external circulation. **

Using 'sdelayer -o add' on an empty DB2 table errors out and forces the user to register the table as a layer with ArcSDE first, using 'sdelayer -o register'. When the table is registered with ArcSDE, if the -C argument and value is not specified, ArcSDE incorrectly defaults to registering the row ID column as user-maintained. It should default to SDE-maintained.

Cause

The 'sdelayer -o add' command is not executing properly; it should add both the spatial and row ID columns and register the table with ArcSDE. This would eliminate the two-step process of adding to and registering the table. Additionally, the -C option has the default value set incorrectly and needs to be corrected.

Workaround

This was fixed in ArcSDE 9.3.1 SP2.

To work around this problem when using 9.2, 9.3, 9.3.1, or 9.3.1 SP1, specify '-C <row_id_column>,SDE' when registering a spatial DB2 table with ArcSDE.

For example:

Code:
sdelayer -o register -l airport,shape -e +a -C oid,SDE 
-t ST_GEOMETRY -x 180,-90,1000000 -G 4326 -g 0.1,0,0 
-i 5500 -u map -p map -q

Consult the ArcSDE Administration Command Reference for more information on using the sdelayer command.

Steps to Reproduce

Bug ID: NIM035936

Software:

No Product Found

Related Information

ArcSDE Administration Command Reference

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options