Bug
The sdelayer -o add command fails with -51 error and deletes the underlying table in DB2.
| Bug ID Number | NIM034197 |
|---|---|
| Submitted | April 11, 2008 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Version Fixed | 9.3 |
| Status | Fixed |
Workaround
After creating the table in DB2, register it with SDE and then run the sdelayer -o add command.C:\>sdetable -o register -t airport -i 5151 -u sde -p sde -k GDT_AIRPORTArcSDE 9.2 for DB2 Build 1239 Thu Jan 24 09:35:02 2008Attribute Administration Utility-----------------------------------------------------Table airport successfully registered.C:\>sdelayer -o add -i 5151 -u sde -p sde -x -180,-90,1000000 -G 4326 -g 0.1,0,0 -e +a -k GDT_AIRPORT -q -l airport,bus_fidSuccessfully Created Layer.Query the database for table:describe table airport;------------------------------------------------------------------------------Column Type Typename schema name Length Scale Nulls------------------------------ --------- ------------------ -------- ----- ------GDT_ID SYSIBM VARCHAR 32 0 Yes STATE_FIPS SYSIBM INTEGER 4 0 Yes COUNTY_FIPS SYSIBM INTEGER 4 0 Yes NAME SYSIBM VARCHAR 50 0 Yes CFCC SYSIBM VARCHAR 3 0 Yes IDENT SYSIBM VARCHAR 4 0 Yes USERS SYSIBM VARCHAR 2 0 Yes BUS_FID DB2GSE ST_MULTIPOLYGON 0 0 Yes OBJECTID SYSIBM INTEGER 4 0 No 9 record(s) selected.Steps to Reproduce
Bug ID: NIM034197
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App