Bug
<z/Os> Creating multiversion views on data with a spatial column will fail.
| Bug ID Number | NIM035334 |
|---|---|
| Submitted | May 16, 2008 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Status | Will Not Be Addressed |
Description
The following error occurs when trying to create a multiversioned view (versioned view) on a table that contains a spatial column in a geodatabase in DB2 z/OS:"SQL20060N The key transform table function used by the index extension of index "DISTINCT TYPE" of table "PARAMETER" in "NEW_FEATURE" generated duplicate rows."
Cause
There is no support for distinct types in the SQL stored procedures.Due to a limitation in what can be stored inside a trigger in DB2 z/OS, ArcGIS uses stored procedures inside the triggers to support the multiversioned (versioned) view implementation. However it is not possible to pass a spatial type to a stored procedure. Therefore, the creation of multiversioned (versioned) views on spatial tables fails.
Workaround
Multiversioned (versioned) views can only be created on nonspatial tables in geodatabases in DB2 z/OS currently.Steps to Reproduce
Bug ID: NIM035334
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