ERROR
This error occurs when attempting to display a view in ArcCatalog:DB2 - The selected object failed to draw: Attribute column not found[SDE.SDE.USA_VIEW]The same view can be loaded in ArcExplorer as a layer, but it does not display. The view was successfully created in ArcSDE 8.1 Service Pack 1 with this command:sdetable -o create_view -T usa_view -t usa -c "usa.shape,usa.state_name" -i sde81_db2 -u sde -p xxxxx
Current implementations of ArcSDE for DB2 and Informix expect a SE_ROW_ID to exist in each spatial spatially-enabled table. This column is used in many operations, including creating views; thus, the view must contain this column.
Include the SE_ROW_ID column when creating views using DB2. The above command should look like this:
Code:
sdetable -o create_view -T usa_view -t usa -c "usa.shape,usa.state_name,usa.se_row_id" -i sde81_db2 -u sde -p xxxxx
Article ID:000004249
Get help from ArcGIS experts
Download the Esri Support App